SGA,PGA 메모리 할당 조회

v$sga_target_advice

col ESTD_DB_TIME for 999999999999999

select sga_size, sga_size_factor, estd_db_time from v$sga_target_advice order by 1;

 

 

V$PGA_TARGET_ADVICE

SELECT round(PGA_TARGET_FOR_ESTIMATE/1024/1024) target_mb, PGA_TARGET_FACTOR,

ESTD_PGA_CACHE_HIT_PERCENTAGE cache_hit_perc,

ESTD_OVERALLOC_COUNT FROM V$PGA_TARGET_ADVICE;