Memory Architecture   «Prev  Next»

Memory Architecture Definitions

Shared pool Contains the data dictionary cache, the shared SQL area, and shared PL/SQL code
LRU list Organizes database buffers in order of use
Program Global Area Contains process specific information
SORT_AREA_SIZE Is the maximum size allowed for a Sort Area
Large pool An area of memory from which large allocations can be made
SORT_AREA_RETAINED_SIZE Is the maximum size to be kept allocated to a Sort Area after a sort has completed
Dirty List Identifies modified buffers in the database buffer cache
Shared SQL Area Contains SQL execution plans so they can be used by all processes