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?