What is Program Global Area (PGA)?

What is Program Global Area (PGA)?

Rating:

The Program Global Area (PGA) is a region in the memory that stores data and control information for a server process. It is created and utilized exclusively by a server process. The PGA consists of a private SQL area and the session memory.

Private SQL area - It stores data such as bind information and runtime memory structures such as stacks. The private area is configured for a session as soon as a SQL statement is issued in the session. The private area of a cursor has two components:

• Persistent area - It stores the bind information and is only released when the cursor is closed.
• Run-time area - It is released only when the execution is completed. The run-time area is created upon receiving the request for execution. For complex queries, a separate area called the SQL work area is configured out of the run-time area.
  

The private area is configured within the PGA when the dedicated server option is chosen. However, if the shared server option is chosen, a part of the private area is configured within the System Global Area (SGA)

Session memory - It is used for storing logon information and other information associated with the session.

Rating: