Content deleted Content added
Tag: section blanking |
|||
Line 120:
* the redo log buffer: this stores redo entries—a log of changes made to the database. The instance writes redo log buffers to the redo log as quickly and efficiently as possible. The redo log aids in instance recovery in the event of a system failure.
* the shared pool: this area of the SGA stores shared-memory structures such as shared SQL areas in the library cache and internal information in the data dictionary. An insufficient amount of memory allocated to the shared pool can cause performance degradation.
*the Large pool Optional area that provides large memory allocations for certain large
processes, such as Oracle backup and recovery operations, and I/O server processes
*Database buffer cache: Caches blocks of data retrieved from the database
*KEEP buffer pool: A specialized type of database buffer cache that is tuned to retain
blocks of data in memory for long periods of time
*RECYCLE buffer pool: A specialized type of database buffer cache that is tuned to
recycle or remove block from memory quickly
*nK buffer cache: One of several specialized database buffer caches designed to hold
block sizes different than the default database block size
J*ava pool:Used for all session-specific Java code and data in the Java Virtual Machine (JVM)
*Streams pool: Used by Oracle Streams to store information required by capture and apply
When you start the instance by using Enterprise Manager or SQL*Plus, the amount of memory allocated for the SGA is displayed.
====Library cache====
| |||