Oracle-Ora-04031故障的分析

#
#2014-09-29
#
#shared pool的使用情况
SELECT free_space,
       avg_free_size,
       used_space,
       avg_used_size,
       request_failures,
       last_failure_size
  FROM v$shared_pool_reserved;
  
#library cache的命中率 软解析
select sum(pinhits) / sum(pins) * 100 
from v$librarycache;


#library cache的命中率 硬解析
select sum(pins) "hits",
       sum(reloads) "misses",
       sum(reloads) / sum(pins) "Hits Ratio"
  from v$librarycache;


#查看隐含参数
SELECT   nam.ksppinm NAME, val.ksppstvl VALUE
  FROM x$ksppi nam, x$ksppsv val
 WHERE nam.indx = val.indx AND nam.ksppinm LIKE '%_db_handles_cached%'
ORDER BY 1;


#其他隐含参数
_shared_pool_reserved_min_alloc 
shared_pool_reserved_size