查询 PGA 性能指标

• 查询 PGA 性能指标：

  
  

  
  

   select name,value,100*( value
       /decode((select sum(value) from v$sysstat
       where name like 'workarea executions%'),0,null,
       (select sum(value) from v$sysstat
       where name like 'workarea executions%'))) pct
      from v$sysstat where name like 'workarea executions%';
  

  
  

  
  

  NAME                                                                  VALUE        PCT（%）

  ---------------------------------------------------------------- ---------- ----------

  workarea executions -optimal                                         18315        100

  workarea executions - onepass                                             0          0

  workarea executions - multipass                                          0          0

  
  

  
  

  
  

  http://hi.baidu.com/beijing6179/item/3257ec30e81e354d7d034b5a