--1.查看表空間使用情況
select (tablespace_name) "表空間名", sum(total_size) "總空間/M", sum(total_free) "剩余空間/M", sum(max_continue) "最大連續空間/M", round(sum(total_free) / sum(total_size) * 100) "剩余百分比/ratio" from ((select tablespace_name, (0) total_size, round(sum(bytes) / 1024 / 1024, 2) total_free, round(max(bytes) / 1024 / 1024, 2) max_continue from dba_free_space group by tablespace_name) union all (select tablespace_name, round(sum(bytes) / 1024 / 1024, 2), 0, 0 from dba_data_files group by tablespace_name)) group by tablespace_name order by 5 asc


--2.查看各個對象的表空間使用情況
select t.owner, t.segment_name, t.segment_type, sum(bytes) / (1024 * 1024) as "size(M)" from dba_segments t --where t.owner IN ('KRMDBA', 'BRMETL', 'ALMRPT') group by t.segment_name, t.segment_type, t.owner

總結

以上是生活随笔為你收集整理的查看表空间使用情况的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。