tailieunhanh - Oracle Architectural Components

After completing this appendix, you should be able to do the following: Describe the Oracle Server architecture and its main components List the structures involved in connecting a user to an Oracle instance List the stages in processing: Queries DML statements Commits | Oracle Architectural Components Schedule: Timing Topic 60 minutes Lecture 60 minutes Total Objectives After completing this appendix, you should be able to do the following: Describe the Oracle Server architecture and its main components List the structures involved in connecting a user to an Oracle instance List the stages in processing: Queries DML statements Commits Objectives This appendix introduces Oracle Server architecture by describing the files, processes, and memory structures involved in establishing a database connection and executing a SQL command. Database Redo log files Control files Data files Overview User process Server process PGA Archived log files Parameter file Password file Instance SGA Redo log buffer Data buffer cache Shared pool Data dict. cache Library cache PMON DBW0 SMON LGWR CKPT Others Overview The Oracle Server is an object relational database management system that provides an open, comprehensive, integrated approach to information management. Primary Components There are several processes, memory structures, and files in an Oracle Server; however, not all of them are used when processing a SQL statement. Some are used to improve the performance of the database, ensure that the database can be recovered in the event of a software or hardware error, or perform other tasks necessary to maintain the database. The Oracle Server consists of an Oracle instance and an Oracle database. Oracle Instance An Oracle instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a system global area (SGA) is allocated and Oracle background processes are SGA is a memory area used to store database information that is shared by database processes. Background processes perform functions on behalf of the invoking process. They consolidate functions that would otherwise be handled by multiple Oracle programs running for . | Oracle Architectural Components Schedule: Timing Topic 60 minutes Lecture 60 minutes Total Objectives After completing this appendix, you should be able to do the following: Describe the Oracle Server architecture and its main components List the structures involved in connecting a user to an Oracle instance List the stages in processing: Queries DML statements Commits Objectives This appendix introduces Oracle Server architecture by describing the files, processes, and memory structures involved in establishing a database connection and executing a SQL command. Database Redo log files Control files Data files Overview User process Server process PGA Archived log files Parameter file Password file Instance SGA Redo log buffer Data buffer cache Shared pool Data dict. cache Library cache PMON DBW0 SMON LGWR CKPT Others Overview The Oracle Server is an object relational database management system that provides an open, comprehensive, integrated approach to information management. .

• Cơ sở dữ liệu
• Oracle Architectural Components
• information technology
• curriculum
• data management
• Oracle Database
• SQL Plus
• Giáo trình Oracle SQL và PL SQL
• Bài giảng Giáo trình Oracle SQL và PL SQL
• Câu lệnh truy vấn
• Quy tắc viết câu lệnh truy vấn
• Câu lệnh SQL
• Lệnh SQL Plus cơ bản
• Mastering Oracle
• SQL and SQL Plus
• Data Definition
• Data Manipulation
• Database Systems and Oracle
• Using Scripts
• Oracle XML Applications
• database
• Oracle XML
• Performance Tuning
• XML Data
• Administration
• Oracle Text Queries
• Beginning Oracle SQL
• Introduction to SQL
• AQL Plus
• and SQL Developer
• công nghệ thông tin
• cơ sở dữ liệu
• tài liệu về cơ sở dữ liệu
• SQL
• Oracle9i
• The Complete Reference
• PL SQL
• Java
• JDBC
• SQLJ
• and XML programming
• cơ sở dữ liệu quan hệ
• database relationship
• thiết kế CSDL quan hệ
• CSDL quản lý khách sạn
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu