[Book Script] 테이블 스페이스 모니터링 하기

SELECT T.NAME , T.BYTES,T.USED,T.FREE,T.PCT_FREE_USED, C.BLOCK_SIZE/1024||'k' BLOCK_SIZE,

       C.EXTENT_MANAGEMENT,

       C.SEGMENT_SPACE_MANAGEMENT,

           A.TABLESPACE_NAME                                              NAME,

           SUM(B.BYTES/1048576)/COUNT( DISTINCT A.FILE_ID||'.'||A.BLOCK_ID ) -

           SUM(A.BYTES/1048576)/COUNT( DISTINCT B.FILE_ID )                       FREE,

                           (SUM(A.BYTES)/COUNT( DISTINCT B.FILE_ID ) )) /

FROM       DBA_FREE_SPACE A, DBA_DATA_FILES B

GROUP BY   A.TABLESPACE_NAME ) T , DBA_TABLESPACES C

ORDER BY T.PCT_FREE_USED ;