標籤：
查看oracle資料庫的大小和空間使用方式(2012-06-19 14:44:30)
轉載▼
1、查看錶空間的使用狀況SELECT upper(f.tablespace_name) 資料表空間名, d.Tot_grootte_Mb "資料表空間大小(M) ", d.Tot_grootte_Mb - f.total_bytes "已使用空間(M) ", round((d.Tot_grootte_Mb - f.total_bytes) / d.Tot_grootte_Mb * 100, 2) "使用比 ", f.total_bytes "空閑空間(M) ", f.max_bytes "最大塊(M) " FROM (SELECT tablespace_name, round(SUM(bytes) / (1024 * 1024), 2) total_bytes, round(MAX(bytes) / (1024 * 1024), 2) max_bytes FROM sys.dba_free_space GROUP BY tablespace_name) f, (SELECT dd.tablespace_name, round(SUM(dd.bytes) / (1024 * 1024), 2) Tot_grootte_Mb FROM sys.dba_data_files dd GROUP BY dd.tablespace_name) d WHERE d.tablespace_name = f.tablespace_name ORDER BY 4 DESC 2、查看無法擴充的段 SELECT segment_name, segment_type, owner, a.tablespace_name "tablespacename ", initial_extent / 1024 "inital_extent(K) ", next_extent / 1024 "next_extent(K) ", pct_increase, b.bytes / 1024 "tablespace max free space(K) ", b.sum_bytes / 1024 "total free space(K) " FROM dba_segments a, (SELECT tablespace_name, MAX(bytes) bytes, SUM(bytes) sum_bytes FROM dba_free_space GROUP BY tablespace_name) b WHERE a.tablespace_name = b.tablespace_name AND next_extent > b.bytes ORDER BY 4, 3, 1
查看oracle資料庫的大小和空間使用方式
