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

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

col name head "Name" for a40
col gets head "Gets" for 999999999
col misses head "Miss" for 999999999
col immediate_gets head "IGets" for 999999999
col immediate_misses head "IMiss" for 999999999

spool all_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.latch#=l.latch#
/

spool off

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