SELECT 'Latch Hit Ratio ' "Ratio",
ROUND ((SELECT SUM (gets) - SUM (misses)
FROM v$latch) / (SELECT SUM (gets)
FROM v$latch) * 100,
2
)
|| '%' "Percentage"
FROM DUAL;