记忆角落

  • {{ item.name }}
  • 首页
  • 关于
  • 归档
  • 邻居
  • 捐赠

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

  • 郭良俊只狗
  • 2018-07-31
  • 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

© 2012 - 2023 记忆角落 网站统计 又拍云CDN赞助
Theme by Wing 粤ICP备14056850号