-- name       : enqueue.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Displays all enqueue statistics
-- limitation : needs access to v$sysstat
--
-- useage     : SQL> @enqueue

set feed off
set head off
set pages 30

col name head "Name" for a25
col value head "Value" for 999,999,999

spool enqueue.lis

select 	name name,
	value value
from 	v$sysstat
where name like '%enqueu%'
/

set feed on
set head on
set pages 24

spool off