DBMS별 Table / Index 용량 확인하는 쿼리

Oracle SELECT a.tablespace_name AS TablespaceName , a.file_name FileName , (a.bytes - b.free) AS Used , b.free AS Free , a.bytes Total FROM ( SELECT file_id , tablespace_name , file_name , SUM(bytes) bytes FROM dba_data_files GROUP BY file_id, tablespace_name, file_name) a, ( SELECT tablespace_name , file_id , SUM(NVL(bytes,0)) FREE FROM dba_free_space GROUP BY tablespace_name, file_id ) B WHERE..

2021.11.11