Skip to content. | Skip to navigation
How to check the Latches Hit Ratio
SELECT name, (1-(misses/gets))*100 AS "Ratio", sleeps FROM v$latch WHERE name in ('library cache', 'shared pool')