-- name       : check_freelist.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: This script check the waits on the freelist
-- limitation : needs access to v$waitstat
--
-- useage     : SQL> @check_freelist

set pages 50
set feed off
set verify off
set linesize 80

spool check_freelist.lis

col class head "Class" for a20
col count head "Count" for 999,999,999

select 	class class,
	count count
from	v$waitstat
where	class = 'free list'
/

spool off

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