The PGA of Oracle Architecture

Pga-program Global Area

The PGA memory area is private and not shared, and any operations initiated by the user against the database, whether queries or updates, are preprocessed in the region before entering the instance area (which is done by the SGA and the system daemon process).

What are the main pretreatment?

First, save the user's connection information, such as session properties, binding variables, etc.;

Second, save the user rights and other important information, when the user process and the database to establish a session, the system will be the user's relevant permissions queried, and then saved in the session area;

Third, when the originating instructions need to sort, then in the PGA, if the memory is not enough to hold the sorted size, then the excess is completed in the temporary table space, that is, on disk.

is an Oracle architecture diagram, a general user-initiated request that needs to go through the-->3 area of the 1 zone-->2 area, or the 1 zone-->2 area

Excerpt from: "Harvest, more than Oracle"

The PGA of Oracle Architecture