What is PGA_AGGREGATE_TARGET parameter?
@ : Home >
> Interview Room
- PGA_AGGREGATE TARGET parameter specifies target aggregate PGA memory available to all server process attached to an instance.
- Oracle sets its value to 20% of SGA.
- It is used to set overall size of work-area required by various components.
- Its value can be known by querying v$pgastat dynamic performance view.
- From sqlplus it can be known by using SQL> show parameter pga.