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;
トップ   一覧 単語検索 最終更新   ヘルプ   最終更新のRSS