doc

    Name:    redlatch.sql

    Author:  Mark Gurry

    This script shows the load balance between the redo allocation latch
    and the redo copy latches. It also shows the misses and immediate
    misses which should ideally be as close to zero as possible. 

#

ttitle 'Redo Allocation and Copy Latch Misses'

SELECT * 
  FROM v$latch
 WHERE name like 'redo%';