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 / |