Show Info for Latches
-- -- Show info for all current latches. -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SELECT l.latch#, l.name, l.gets, l.misses, l.sleeps, l.immediate_gets, l.immediate_misses, l.spin_gets FROM v$latch l ORDER BY sleeps DESC, misses DESC, gets DESC /