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.
Alert me