select a.tablespace_name "表空间名",
total "表空间大小",
free "表空间剩余大小",
(total - free) "表占用空间大小",
round((total - free) / total * 100,2) || '%' "已使用空间百分比"
from (select tablespace_name,sum(bytes) / 1024 / 1024 total
from dba_data_files
group by tablespace_name) a,
(</
navicat处理oracle数据库基础篇-03
于 2024-02-26 17:49:47 首次发布

最低0.47元/天 解锁文章
1880





