v$pga_target_advice

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命中的百分比

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

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