-- File Name: redolatches.sql
-- Redo Latches - Show Statistics
column name format A28
column gets format 999999999
column misses format 99999999
column sleeps format 9999999
column immediate_gets format 99999999
column immediate_misses format 99999999
set pagesize 100
select name,
       sum(gets) gets,
       sum(misses) misses,
       sum(immediate_gets) immediate_gets,
       sum(immediate_misses) immediate_misses
from v$latch
where name like '%redo%'
group by name;