推荐ORACLE很好的入门教材重点.pptVIP

* * * . * Redo Log Buffer Cache The redo log buffer cache is a circular buffer that contains changes made to data file blocks. This information is stored in redo entries. Redo entries contain the information necessary to recreate the data prior to the change made by INSERT, UPDATE, DELETE, CREATE, ALTER, or DROP operations. Sizing the Redo Log Buffer Cache The size of the redo log buffer cache is defined by the initialization parameter LOG_BUFFER. Note: Sizing the Redo Log Buffer Cache is covered in further detail in the Oracle9i Performance Tuning course. Refer to the Managing Redo Log Files lesson for details regarding redo log files. * Large Pool When users connect through the shared server, Oracle needs to allocate additional space in the shared pool for storing information about the connections between the user processes, dispatchers, and servers. The large pool relieves 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. Sizing the Large Pool The large pool is sized in bytes defined by the LARGE_POOL_SIZE parameter. * Java Pool The Java pool is an optional setting but is required if 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 24M. * Program Global Area Components The Program Global Area or Process Global Area (PGA) is a memory region that contains data an