col Tablespace_Name format a20 col Pct_Increase format 999 heading ’PCT|INCR’ select Tablespace_Name,
Initial_Extent, Next_Extent, Min_Extents, Max_Extents, Pct_Increase from DBA_TABLESPACES;
column sys_date noprint column owner format a12 heading "OWNER" column segent_name format a25 heading "SEGMENT|NAME" column segment_type format a10 trunc heading "SEGMENT|TYPE" column kbytes format 9,999,999 heading "KBYTES" column extents format 9,999,999 heading "EXTENTS" column max_extents format 9,999,999 heading "MAX|EXTENTS" set newpage 0 break on owner skip page compute num on segent_name select to_char(sysdate,’YYYY-MM-DD Dy HH:MI PM’) sys_date
,ds.owner ,ds.segment_name ,ds.segment_type ,ds.bytes/1024 kbytes ,ds.extents ,ds.max_extents
from sys.dba_segments ds where ds.max_extents < 2147483645 order by ds.owner
,ds.extents desc;
set term off verify off echo off feedback off set linesize 120 pagesize 60 col Value new_value blksz noprint col Maxext format 9,999,999,999,999 heading ’MAXIMUM|EXTENDED SIZE’ col Incr format 9,999,999,999,99 heading ’EXTENSION|INCREMENT’ col Tablespace_Name format a15 heading ’TABLESPACE’ col File_Name format a50 heading ’FILE NAME’
select Value
from V$PARAMETER where Name = ’db_block_size’;
set term on
select Tablespace_Name,
File_Name, Maxextend*&&blksz Maxext, Inc*&&blksz Incr from DBA_DATA_FILES, SYS.FILEXT$ where File_Id=File#(+) order by Tablespace_Name, File_Name;