디스크 사용량

select        t.tablespace_name 
        ,       d.file_name
        ,       d.bytes/1024/1024 "Size (MB)"
        ,       to_char((e.blocks * 8192) / 1024 / 1024, '999') "Used (MB)"
        ,       to_char(nvl(round(e.blocks / d.blocks, 4), 0) * 100, '09.99') || ' %' "pct"
        ,       t.segment_space_management
        ,       t.extent_management
        ,       d.autoextensible
from
        dba_data_files d
join
        (
                select file_id, sum(nvl(blocks, 0)) blocks
                from dba_extents
                group by file_id
        ) e
on
        d.file_id = e.file_id
join
        dba_tablespaces t
on
        d.tablespace_name = t.tablespace_name

속도가 좀 느림.


&