/*
|| 表領域情報
||
*/
set echo off
set lines 180
set pages 100
clear col
ttitle off
col TABLESPACE form a30 head “表領域名”
col INIT_EXT form 999,999 head “INIT_EXT(KB)”
col NEXT_EXT form 999,999 head “NEXT_EXT(KB)”
col MIN_EXT form 99 head “MIN_EXT”
col EXT_MAN form a10 head “EXT管理”
col ALLOC form a10 head “ALLOC”
col bigfile form a10 head “BIG表領域”
col logging form a10 head “LOGGING”
col max_size form 999,999 head “MAX(OraBlk)”
ttitle left ‘■■■■ 表領域記憶域情報 ■■■■’
spool d:\tbs_man_info.lis
SELECT
tablespace_name TABLESPACE
,initial_extent/1024 INIT_EXT
,next_extent/1024 NEXT_EXT
,min_extents MIN_EXT
,extent_management EXT_MAN
,allocation_type ALLOC
,bigfile
,logging
,max_size/(1024*1024) MAX_SIZE
FROM dba_tablespaces
;
spool off
clear col
ttitle off
