What Does System Global Area (SGA) Mean?#
Techopedia Explains System Global Area (SGA)#
- Dictionary cache: Holds data dictionary table information, such as information regarding accounts, segments, data files, tables and privileges
- Redo log buffer: Includes information about committed transactions that have not yet been written to online redo log files
- Buffer_cache: Holds a copy of data blocks read from data files
- Shared pool: Holds a cache of parsed and commonly used Structured Query Language (SQL) statements
- Java pool: Parses Java statements
