-- name       : redo_latch.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show the latch statistics
-- limitation : needs access to v$latch and v$latchname
--
-- useage     : SQL> @redo_latch

set pages 50
set feed off
set verify off
set linesize 200

col name head "Name" for a15
col gets head "Gets" for 999999
col misses head "Miss" for 999999
col immediate_gets head "I-Gets" for 999999
col immediate_misses head "I-Miss" for 999999

spool redo_latch.lis

ttitle  'LATCH STATISTICS'

select 	ln.name name,
	gets gets,
	misses misses,
	immediate_gets immediate_gets,
	immediate_misses immediate_misses
from 	v$latch l,
	v$latchname ln
where 	ln.name in ('redo allocation','redo copy')
and 	ln.latch#=l.latch#
/

spool off

set pages 24
set feed on
set verify on
set lines 80