Oracle基础架构培训资料课件.pptVIP

Redo Log Buffer The Redo Log Buffer is a circular buffer that contains changes made to datafile blocks. This information is stored in redo entries. Redo entries contain the information necessary to re-create the data prior to the change made by INSERT, UPDATE, DELETE, CREATE, ALTER, or DROP operations. Sizing the Redo Log Buffer The size of the Redo Log Buffer is defined by the LOG_BUFFER initialization parameter. Note: Sizing the Redo Log Buffer is covered in further detail in the Oracle9i Database Performance Tuning course. Refer to the “Managing Redo Log Files” lesson for details regarding online redo log files. Large Pool By allocating session memory from the Large Pool for Shared Server, Oracle XA, or parallel query buffers, Oracle can use the Shared Pool primarily for caching Shared SQL statements. Thus relieving the burden on areas within the Shared Pool. The Shared Pool does not have to give up memory for caching SQL parse trees in favor of Shared Server session information, I/O, and backup and recover processes. The performance gain is from the reduction of overhead from increasing and shrinkage of the shared SQL cache. Backup and Restore Recovery Manager (RMAN) uses the Large Pool when the BACKUP_DISK_IO=n and BACKUP_TAPE_IO_SLAVE=TRUE parameters are set. If the Large Pool is configured but is not large enough, the allocation of memory from the Large Pool fails. RMAN writes an error message to the alert log file and does not use I/O slaves for backup or restore. Parallel Execution The Large Pool is used if PARALLEL_AUTOMATIC_TUNING is set to TRUE, otherwise, these buffers are allocated to the Shared Pool. Java Pool The Java Pool is an optional setting but is required if you are installing and using Java. Its size is set, in bytes, using the JAVA_POOL_SIZE parameter. In Oracle9i, the default size of the Java Pool is 24 MB. Program Global Area (PGA) The Program Global Area or Process Global Area (PGA) is a memory region that contains data and control informa