查看数据库消耗情况的sql–oralce

/ 0评 / 0
SELECT a.tablespace_name "表空间名",
       total / (1024 * 1024 * 1024) 表空间大小G,
       free / (1024 * 1024 * 1024) 表空间剩余大小,
       (total - free) / (1024 * 1024 * 1024) 表空间使用大小,
       ROUND((total - free) / total, 4) * 100 "使用率 %"
  FROM (SELECT tablespace_name, SUM(bytes) free
          FROM DBA_FREE_SPACE
         GROUP BY tablespace_name) a,
       (SELECT tablespace_name, SUM(bytes) total
          FROM DBA_DATA_FILES
         GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name
   --and a.tablespace_name = 'MMDS_DATA';
   
   

SELECT SEGMENT_NAME, SUM(BYTES)/1024/1024/1024 GB 
FROM USER_SEGMENTS 
WHERE TABLESPACE_NAME='MMDS_DATA'
--AND SEGMENT_NAME LIKE 'WDIG%'
GROUP BY SEGMENT_NAME
ORDER BY GB DESC NULLS LAST

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注