Tablespace Size 조회 Script

set LINESize 130 COL TABLESPACE FORMAT A10 COL TOT_MB FORMAT 9,999,999.99 COL USE_MB FORMAT 9,999,999.99 COL FREE_MB FORMAT 9,999,999.99 COL USED(%) FORMAT 999.99 COL INI_KB FORMAT 999,999,999 COL NEXT_KB FORMAT 999,999,999 COL PCT_IN FORMAT 999 SELECT A.TABLESPACE_NAME TABLESPACE, SUM(A.BYTES)/(1024*1024) AS TOT_MB, SUM(A.BYTES)/(1024*1024) – SUM(SZ_KB)/(1024*1024) AS USE_MB, SUM(SZ_KB)/(1024*1024) AS FREE_MB, (1-(SUM(SZ_KB)/SUM(A.BYTES)))*100 AS “USED(%)” FROM DBA_DATA_FILES A, ( SELECT FILE_ID, SUM(BYTES) AS SZ_KB FROM DBA_FREE_SPACE GROUP BY FILE_ID) B, DBA_TABLESPACES C WHERE A.FILE_ID = B.FILE_ID and A.TABLESPACE_NAME = C.TABLESPACE_NAME and A.TABLESPACE_NAME in (‘ARD’,’ARX’,’APD’,’APX’,’GLD’,’GLX’,’FAD’,’FAX’,’JAD’,’JAX’,’JGD’,’JGX’,’XTRD’,’XTRX’, ‘INVD’,’INVX’,’POD’,’POX’,’HRD’,’HRX’, ‘HXCD’,’HXCX’,’HXTD’,’HXTX’,’OTAD’,’OTAX’,’EHRD’,’EHRX’, ‘LGEIFD’,’LGEIFX’,’APPLSYSD’,’APPLSYSX’, ‘OED’,’OEX’,’ONTD’,’ONTX’,’WSHD’,’WSHX’,’ASOD’,’ASOX’,’QPD’,’QPX’) GROUP BY A.TABLESPACE_NAME;