查看表空间已使用和剩余空间大小
--表空间的总容量和空闲空间,表空间的碎片个数和最大的碎片
select t.tablespace_name,TOTAL_MB-FREE_MB userd_mb,FREE_MB,TOTAL_MB,number_space,max_space
from
(SELECT TABLESPACE_NAME,TRUNC(SUM(BYTES)/1024/1024) TOTAL_MB
FROM DBA_data_files
GROUP BY TABLESPACE_NAME) t,
(SELECT TABLESPACE_NAME,TRUNC(SUM(BYTES)/1024/1024) FREE_MB,
count(*) number_space,round(max(bytes)/1024/1024) max_space
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) f
where t.tablespace_name=f.tablespace_name
order by number_space desc;
select t.tablespace_name,TOTAL_MB-FREE_MB userd_mb,FREE_MB,TOTAL_MB,number_space,max_space
from
(SELECT TABLESPACE_NAME,TRUNC(SUM(BYTES)/1024/1024) TOTAL_MB
FROM DBA_data_files
GROUP BY TABLESPACE_NAME) t,
(SELECT TABLESPACE_NAME,TRUNC(SUM(BYTES)/1024/1024) FREE_MB,
count(*) number_space,round(max(bytes)/1024/1024) max_space
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) f
where t.tablespace_name=f.tablespace_name
order by number_space desc;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28275505/viewspace-1814594/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
实例进程
下一篇：
exp,imp/expdp,impdp
请登录后发表评论
登录
全部评论
