Database Administration (MOSC)

MOSC Banner

v$pga_target_advice: PGA_TARGET_FOR_ESTIMATE and pga_aggregate_target

** this is for 19c(19.18.0.0.0)

when i query v$pga_target_advice, was PGA_TARGET_FOR_ESTIMATE referring to pga_aggregate_target.

PGA TARGET           PGA_TARGET_FACTOR 

---------- ---------- ------------ ----------------

   2250    .75   

   3000     1    

   3600    1.2    

SQL> show parameter pga

pga_aggregate_limit         big integer 6000M

pga_aggregate_target         big integer 1G


I was expecting v$pga_target_advice to show pga target as 1G for factor of 1, but i see it had 3G for that. Did i misunderstood that numbers?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center