脚本之查询Shared Pool空闲率

以下语句可以查询Shared Pool空闲率：

SQL> select to_number(v$parameter.value) value, v$sgastat.BYTES,

  2         (v$sgastat.bytes/v$parameter.value)*100 "percent free"

  3      from v$sgastat, v$parameter

  4      where v$sgastat.name= 'free memory'

  5      and v$parameter.name = 'shared_pool_size'

  6      and v$sgastat.pool='shared pool'

  7  ;

     VALUE      BYTES percent free

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

 503316480  141096368 28.033329645

SQL>