set
feed off
set echo off
set head on
set verify off
REM
REM
REM ||Title : show_tablespaces8i.sql
REM ||
REM || Author : Surjit Hunjan
REM ||
REM || Date Written : 29/08/99
REM ||
REM || Purpose : Displays information about tablespaces
for
REM || a database instance. Version 8.i only
REM ||
REM ||
REM || Release No : 1
REM ||
REM || Variables : None
REM ||
REM || Schema :
REM ||
REM ||
REM || Modification History:
REM ||
REM || Who Date Reason Release No
REM || ------------ ----------
------------------------------ -----------------------
REM || Surjit Hunjan 29/08/00 Initial Creation 1
REM ||
REM ||
REM
COL tablespace_name FORMAT A15 HEADING 'Tablespace|Name'
JUSTIFY L
COL initial_extent FORMAT 999,999 HEADING 'Initial|Extent
Mb' JUSTIFY L
COL next_extent FORMAT 999,999 HEADING 'Next|Extent Mb'
JUSTIFY L
COL max_extents FORMAT 99999999999 HEADING 'Max|Extent'
JUSTIFY L
COL pct_increase FORMAT 999,999 HEADING 'Pct|Increase'
JUSTIFY L
COL status FORMAT A10 HEADING 'Status' JUSTIFY L
COL extent_management FORMAT A10 HEADING 'Extent|Management'
JUSTIFY L
COL allocation_type FORMAT A10 HEADING 'Allocation|Type'
JUSTIFY L
SELECT tablespace_name,
initial_extent/1024/1024 initial_extent,
next_extent/1024/1024 next_extent,
max_extents,
pct_increase,
status,
extent_management,
allocation_type
FROM dba_tablespaces
ORDER by tablespace_name
SPOOL tablespaces_util.lis
/
SPOOL OFF
SET SERVEROUTPUT ON
SET FEEDBACK ON