Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Architectural Components

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

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 started.The 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. .