데이터베이스 품질관리 [표준화] [분석] [통계]

SELECT u.tablespace_name "테이블스페이스명",
             u.bytes / 1024000 "크기(MB)",
             (u.bytes - sum(nvl(f.bytes,0))) / 1024000 "사용됨(MB)",
             (sum(nvl(f.bytes,0))) / 1024000 "남음(MB)",
             trunc((sum(nvl(f.bytes,0)) / u.bytes) * 100,2) "남은 %"
FROM DBA_FREE_SPACE f, DBA_DATA_FILES u
WHERE f.file_id(+) = u.file_id
GROUP BY u.tablespace_name, u.file_name, u.bytes
ORDER BY u.tablespace_name;


SELECT 'datafile' what,file_id,tablespace_name,file_name,relative_fno,f.bytes,autoextensible,maxbytes,
     f.bytes-NVL(s.bytes,0) bytes_used
     FROM DBA_DATA_FILES f left outer join (
         SELECT file_id,tablespace_name,relative_fno,SUM(bytes) bytes
         FROM DBA_FREE_SPACE GROUP BY file_id,tablespace_name,relative_fno
         ) s USING (file_id,tablespace_name,relative_fno)