Oracle‎ > ‎Performance Tuning‎ > ‎

PGA

Use this query to see what the optimal PGA_AGGREGATE_TARGET setting is for a running system, based on recent activity.

SELECT round(PGA_TARGET_FOR_ESTIMATE/1024/1024) target_mb, ESTD_PGA_CACHE_HIT_PERCENTAGE cache_hit_perc, ESTD_OVERALLOC_COUNT FROM V$PGA_TARGET_ADVICE;
Comments