Library Cache

library_cache_miss

rem library misses

set lines 80;
set pages 999;
column mydate heading 'Yr. Mo Dy Hr.' format a16
column c1 heading 'execs' format 9,999,999
column c2 heading 'Cache Misses|While Executing' format 9,999,999
column c3 heading 'Library Cache|Miss Ratio' format 999.99999
break on mydate skip 2;
set lines 80;
set pages 999;
select
  namespace,
  gets  locks,
  gets - gethits  loads,
  pins,
  reloads,
  invalidations
from
  sys.v_$librarycache
where
  gets > 0
order by
  2 desc
/



RAC
rem library misses

set trimspool on;
column mydate heading 'Yr. Mo Dy Hr.' format a16
column c1 heading 'execs' format 9,999,999
column c2 heading 'Cache Misses|While Executing' format 9,999,999
column c3 heading 'Library Cache|Miss Ratio' format 999.99999
break on mydate skip 2;
set lines 200;
set pages 999;
select
  inst_id,namespace,
  gets  locks,
  gets - gethits  loads,
  pins,
  reloads,
  invalidations
from
  sys.gv_$librarycache
where
  gets > 0
order by
  1,2 desc
/




  Sign in   Recent Site Activity   Terms   Report Abuse   Print page  |  Powered by Google Sites