-- name       : resource_limits.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show the resource HWM's and limits
-- limitation : needs access to v$resource_limit
--
-- useage     : SQL> @resource_limits

set pages 50
set feed off
set echo off
set verify off

col resource_name head "Resource" for a30
col current_utilization head "Current" for 999
col max_utilization head "Max" for 999
col initial_allocation head "initial" for a10
col limit_value head "Limit" for a10

spool resource_limits.lis

ttitle 'Resource Limits'

select	resource_name resource_name,
	current_utilization current_utilization,
	max_utilization max_utilization,
	initial_allocation initial_allocation,
	limit_value limit_value
from	v$resource_limit;

spool off

set feed on
set head on
set pages 24
set verify on