Oracle Database - System Global Area - SGA (Shared Memory)

Card Puncher Data Processing

Oracle Database - System Global Area - SGA (Shared Memory)

About

The SGA (System Global Area) is an area of memory allocated when an Oracle Instance starts up.

The SGA memory is shared by all sessions connected to Oracle Instance. See Virtual Memory - Shared Memory (SHM)

A group of shared memory structures that contain data and control information for an Oracle instance.

Oracle Database Sga

where:

Configuration

The SGA's size and function are controlled by initialization (INIT.ORA or SPFILE) parameters.





Discover More
Card Puncher Data Processing
Oracle Database - Buffer cache

For many types of operations, Oracle Database uses the buffer cache to store data blocks read from disk. Oracle Database bypasses the buffer cache for particular operations, such as sorting and parallel...



Share this page:
Follow us:
Task Runner