RE: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY

From: Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
Date: Fri, 6 Oct 2017 15:05:54 -0700
Message-ID: <CANRhLpCH1SNxY9AjmCXuLtKKC3oSN+TChDq0gocNXN9CskodJA_at_mail.gmail.com>

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




--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image.png

Received on Sat Oct 07 2017 - 00:05:54 CEST

This message: [ Message body ]
Next message: Mladen Gogala: "Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY"
Previous message: Jack Applewhite: "V$XML_Audit_Trail.Action"
Next in thread: Mladen Gogala: "Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY"
Reply: Mladen Gogala: "Re: PGA_AGGREGATE_TARGET, AUTO PGA TARGET and WORKAREA_SIZE_POLICY"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message