COL LATCH FORMAT A36
SELECT name latch, gets, misses, 100 - round( misses*100/decode(gets,0,1,gets), 2 ) eficiencia, sleeps
FROM v$latch
WHERE gets > 0 and 100 - round( misses*100/decode(gets,0,1,gets), 2 ) < 100
ORDER BY eficiencia
/