SET LINESIZE 500 set pagesize 80 SELECT l.latch#, l.name, l.gets, l.misses, l.sleeps, l.immediate_gets, l.immediate_misses, l.spin_gets FROM v$latch l WHERE l.misses > 0 ORDER BY l.misses DESC; LATCH# NAME GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES SPIN_GETS ---------- ---------------------------------------------------------------- ---------- ---------- ---------- 155 cache buffers chains 1.3477E+11 973105288 1316978 1.6868E+10 2066703 971673923 245 undo global data 8386769783 127296652 22251 0 0 127274853 280 row cache objects 753491792 2591911 392 34986 0 2591532 26
The Oracle, Unix and Technology World