ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¬d¸ß¦Utablespace¥Ø«e¨Ï¥Î®e¶q

¬d¸ß¦Utablespace¥Ø«e¨Ï¥Î®e¶q

//¬d¸ß¦Utablespace¥Ø«e¨Ï¥Î®e¶q
col tablespace_name for a20
col file_name for a50
col auto_extend for a12
set linesize 200
set pagesize 500

select
a.tablespace_name,
a.file_name,
a.total "Total(MB)",
round(a.total-b.Free_Space) "Used(MB)",
round(((a.total-b.Free_Space)/a.total)*100,2) "Used(%)",
a.auto_extend
from
(select
FILE_ID,
tablespace_name,
file_name,
bytes/(1024*1024) Total,
AUTOEXTENSIBLE auto_extend
from
dba_data_files ddf) a,
(select
file_id,
sum(bytes)/(1024*1024) Free_Space
from
dba_free_space
group by file_id) b
where
a.file_id=b.file_id
and a.tablespace_name not in ('SYSTEM','SYSAUX')

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD