Memory Architecture

The important memory structures associated with an Oracle database instance are the System Global Area (SGA) and the Program Global Area (PGA). As you know, an Oracle instance is made up of SGA and Oracle processes. Oracle allocates memory for the SGA on database startup and returns the memory when the instance is shut down. The size of the SGA is controlled by the sga_max_size initialization parameter in the initInstance.ora file or the server parameter (SPFILE) file.

System Global Area (SGA)

The System Global Area (SGA) is a group of shared memory structures in the Oracle database instance that has the data and control information for the instance. When multiple users are connected to the same database instance, the SGA ...

Get Oracle® Database 10g Insider Solutions 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.