태그: 데이터파일

현재 사용률 조회 select df.tablespace_name “Tablespace”, round(df.TBS_byte /1048576,2) “Total(MB)”, round((df.TBS_byte – fs.Free_byte)/1048576,2) “Used(MB)”, round(fs.Free_byte /1048576,2) “Free(MB)”, round((fs.Free_byte/df.TBS_byte) *100,0) “Free(%)”, fs.pieces “Pieces”, round(fs.Max_free /1048576,2) “MaxFree(MB)”, db.EXTENT_MANAGEMENT from ( select tablespace_name, sum(bytes)…