O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required