Also known as Process/Private Global Area is the private area attached to each individual user process. It works on behalf of the server process. It is created with the creation of server process and is terminated as soon as server process finishes serving that particular user process.
The number of PGAs is dependent on which mode your database server is running. When the database is in dedicated mode there is a PGA for each server process. But when the server is in shared mode then the PGA is only one and behaves like a container. The container PGA consists of individual UGAs (User Global Area) - one for each user process.
The lines below describe the Structure of Individual PGA/UGA.
The number of PGAs is dependent on which mode your database server is running. When the database is in dedicated mode there is a PGA for each server process. But when the server is in shared mode then the PGA is only one and behaves like a container. The container PGA consists of individual UGAs (User Global Area) - one for each user process.
The lines below describe the Structure of Individual PGA/UGA.
- private SQL area,
- Cursor information and
- session information
