v$pga_target_advice
与v$sga_target_advice类似,给出pga调整后性能的变化
PGA_TARGET_FACTOR为1的列表示当前pga大小
pga_target_for_estimate对应调整后pga的大小
estd_pga_cache_hit_percentage表示pga中cache命中的百分比
PGA_TARGET_FACTOR为1的列表示当前pga大小
pga_target_for_estimate对应调整后pga的大小
estd_pga_cache_hit_percentage表示pga中cache命中的百分比
SQL> desc v$pga_target_advice
Name Null? Type
----------------------------------------- -------- ----------------------------
PGA_TARGET_FOR_ESTIMATE NUMBER
PGA_TARGET_FACTOR NUMBER
ADVICE_STATUS VARCHAR2(3)
BYTES_PROCESSED NUMBER
ESTD_EXTRA_BYTES_RW NUMBER
ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
ESTD_OVERALLOC_COUNT NUMBER
Name Null? Type
----------------------------------------- -------- ----------------------------
PGA_TARGET_FOR_ESTIMATE NUMBER
PGA_TARGET_FACTOR NUMBER
ADVICE_STATUS VARCHAR2(3)
BYTES_PROCESSED NUMBER
ESTD_EXTRA_BYTES_RW NUMBER
ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
ESTD_OVERALLOC_COUNT NUMBER
SQL> SELECT pga_target_for_estimate / 1024 / 1024 "PGA(MB)",
2 pga_target_factor,
3 estd_pga_cache_hit_percentage,
4 estd_overalloc_count
5 FROM v$pga_target_advice;
PGA(MB) PGA_TARGET_FACTOR ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
---------- ----------------- ----------------------------- --------------------
1250 .125 79 73982
2500 .25 99 0
5000 .5 99 0
7500 .75 99 0
10000 1 99 0
12000 1.2 100 0
14000 1.4 100 0
16000 1.6 100 0
18000 1.8 100 0
20000 2 100 0
30000 3 100 0
40000 4 100 0
60000 6 100 0
80000 8 100 0
---------- ----------------- ----------------------------- --------------------
1250 .125 79 73982
2500 .25 99 0
5000 .5 99 0
7500 .75 99 0
10000 1 99 0
12000 1.2 100 0
14000 1.4 100 0
16000 1.6 100 0
18000 1.8 100 0
20000 2 100 0
30000 3 100 0
40000 4 100 0
60000 6 100 0
80000 8 100 0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-689660/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13177610/viewspace-689660/