查看表空间(oracle)占用情况

最新推荐文章于 2024-04-18 19:46:34 发布

gogo_yueyue

最新推荐文章于 2024-04-18 19:46:34 发布

阅读量237

点赞数

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/gogo_yueyue/article/details/84609090

版权

数据库专栏收录该内容

42 篇文章 0 订阅

订阅专栏


select total.tablespace_name,round(total.MB,2) as Total_MB,
round(total.MB-free.MB, 2) as Used_MB
from (select tablespace_name, sum(bytes)/1024/1024 as MB from dba_free_space group by tablespace_name) free,
(select tablespace_name, sum(bytes)/1024/1024 as MB from dba_data_files group by tablespace_name) total 
where free.tablespace_name=total.tablespace_name