SELECT SUBSTR(name,1,20) "Latch", sum(gets),sum(misses),
sum(immediate_gets),sum(immediate_misses)
from v$latch where name like '%redo%'
group by name
/
Hosted by www.Geocities.ws

1