Memory Management
Oracle makes use of a dedicated memory area shared by Oracle system processes and shadow processes, as well as private memory areas used by individual shadow processes.
System Global Area (SGA)
The database shared memory area plays a key role in the operation of the Oracle instance. It provides a storage area so that commonly used objects such as database blocks and optimized SQL statements can be cached for use by other processes. It also facilitates the communication between Oracle system processes (for example, sharing locking information). Oracle refers to this shared memory area as the system global area (SGA).
The SGA consists of the following major components:
Data block buffer cache. The buffer cache provides one ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
