![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
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;
