테이블 스페이스 사용현황 확인

SELECT
        DISTINCT D.FILE_ID FILE#
      , D.TABLESPACE_NAME TS_NAME
      , D.BYTES /1024 / 1024 MB
      , D.BYTES / 8192 TOTAL_BLOCKS
      , SUM(E.BLOCKS) USED_BLOCKS
      , TO_CHAR( NVL( ROUND( SUM(E.BLOCKS)/(D.BYTES/8192), 4),0) *100,'09.99') || ' %' PCT_USED
FROM    DBA_EXTENTS E
      , DBA_DATA_FILES D
WHERE   1 = 1
AND     D.FILE_ID = E.FILE_ID(+)
GROUP BY D.FILE_ID , D.TABLESPACE_NAME , D.BYTES
ORDER BY 1,2 ;

SELECT * FROM dba_data_files;
SELECT * FROM dba_tablespaces;

쿼리작성 : 칼찬요정님(http://blog.naver.com/osunzip)