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
Last-modified: 2017-05-08 (月) 12:38:35 (558d)