|
select
TABLESPACE_NAME 名前,
CONTENTS タイプ,
EXTENT_MANAGEMENT エクステント管理,
round(FSIZE/1000000) "サイズ(M)",
(FSIZE-FREESIZE)/1000000 "使用量(M)"
from
DBA_TABLESPACES,
(
select
V$TABLESPACE.NAME TNAME1,
sum(BYTES) FSIZE
from V$TABLESPACE,V$DATAFILE
where
V$TABLESPACE.TS# = V$DATAFILE.TS#
group by V$TABLESPACE.NAME
) TSIZE,
(
select
TABLESPACE_NAME AS TNAME2,
sum(BYTES) AS FREESIZE
from DBA_FREE_SPACE
group by TABLESPACE_NAME
) TFREE
where
TABLESPACE_NAME = TNAME1 and
TABLESPACE_NAME = TNAME2
| |