- 追加された行はこの色です。
- 削除された行はこの色です。
#author("2017-05-08T09:24:35+09:00","","")
What lirtiaebng knowledge. Give me liberty or give me death.
#freeze
#author("2017-05-08T17:21:15+09:00","","")
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;