ITPub博客

首页 > Linux操作系统 > Linux操作系统 > v$pga_target_advice

v$pga_target_advice

原创 Linux操作系统 作者:安佰胜 时间:2011-03-16 16:49:38 0 删除 编辑

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
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13177610/viewspace-689660/,如需转载,请注明出处,否则将追究法律责任。

上一篇: v$sga_target_advice
下一篇: v$open_cursor
请登录后发表评论 登录
全部评论

注册时间:2009-08-26

  • 博文量
    215
  • 访问量
    618100