--SET DEFINE OFF;
--SET FEEDBACK      OFF
--SET TRIMSPOOL     ON
--SET VERIFY       OFF
--SET LINESIZE 3500

--SET LINESIZE 3500
--SET PAGESIZE   0
--SET VERIFY     OFF
SET FEEDBACK   OFF
SET LINESIZE 3500
SET VERIFY     OFF

alter session set nls_numeric_characters = ',.';

-- Disect the input argument, and get the owner name and table name into two seperate 
-- substitution variables. The owner name defaults to the current user.



@@header_dbinfo 107 DC

CLEAR COLUMNS;

COLUMN FILE_TYPE                 FORMAT A14                        HEADING "File Type";
COLUMN PERCENT_SPACE_USED        FORMAT 9G999G999G999              HEADING "% Space used";
COLUMN PERCENT_SPACE_RECLAIMABLE FORMAT 9G999G999G999              HEADING "% Space reclaimable";
COLUMN NUMBER_OF_FILES           FORMAT 9G999G999G999              HEADING "N. Files";


select RESOURCE_NAME,CURRENT_UTILIZATION CUR_UTILIZATION,MAX_UTILIZATION,INITIAL_ALLOCATION INIT_ALLOC,LIMIT_VALUE LIMIT_VAL
from V$RESOURCE_LIMIT order by resource_name;

SET FEEDBACK ON
CLEAR BREAKS
CLEAR COMPUTE