IN ORACLE MILIEU …

Correct size of PGA You can get the correct size of PGA using V$PGA_TARGET_ADVICE, dynamic performance view. SQL> SELECT ROUND(pga_target_for_estimate/1024/1024) target_mb, 2 estd_pga_cache_hit_percentage cache_hit_perc, 3 estd_overalloc_count 4 FROM V$PGA_TARGET_ADVICE; TARGET_MB CACHE_HIT_PERC ESTD_OVERALLOC_COUNT ———- ————– ——————– 512 98 909 1024 100 0 2048 100 0 3072 100 0 4096 100 0 4915 100 0 5734 100 [...]