Oracle Database - PGA_AGGREGATE_TARGET Parameter

Card Puncher Data Processing

About

PGA_AGGREGATE_TARGET is a database initialization parameter and controls the total amount of execution memory that can be allocated by Oracle for the Process global area (PGA)

PGA_AGGREGATE_TARGET = (TOTAL_MEM * 80%) * 50%

The Total Memory here refers to the total memory available in the system. Please note this is outside SGA

Oracle attempts to keep the amount of private memory below the target you specified by adapting the size of the work areas.

When you increase the value of this parameter, you indirectly increase the memory allotted to work areas.

Consequently, more memory intensive operations are able to run fully in memory and less will work their way over to disk.

In parallel environment

For environments that run a lot of parallel operations (such as a DataWarehouse), you should set pga_aggregate_target as large as possible. A good rule of thumb is to have a minimum of 100MB X parallel_max_servers

PGA_AGGREGATE_TARGET = 100MB X parallel_max_servers.





Discover More
Card Puncher Data Processing
Oracle Database - Process global area (PGA) - Work Area

The PGA memory is a memory allocated for each session. The PGA (Program or Process Global Area) is a memory area that stores data and control information for a single server process. It typically contains...
Oracle Database Direct Path Read Temp With Parallel Slave
Oracle Database - direct path read temp and direct path read wait event

“direct path read temp” and “direct path read” event are wait events. When a session is reading buffers from disk directly into the PGA (opposed to the buffer cache in SGA), it waits on this event....



Share this page:
Follow us:
Task Runner