RE: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY

  • From: Ravi Teja Bellamkonda <raviteja.bellamkonda7@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Oct 2017 15:05:54 -0700

Hi List,

[image: Inline image 1]

In the snippet, PGA TARGETE EST is 79,872 MB where as my
PGA_AGGREGATE_TARGET is 40000.

It would be really helpful if someone can throw some light on this. I
understand that workarea_size_policy parameter set to auto is related to
this. But wanted to confirm that PGA used actually crosses the
PGA_AGGREGATE_LIMIT. Is there any documentation which states that
PGA_AGGREGATE_LIMIT is a soft limit.

It would be very helpful, if someone can clarify.

-- 
Thanks & Regards,
Ravi Teja

PNG image

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2017