oracle表空间管理

表空间大小和利用率查询

select upper(f.tablespace_name) "表空间名",       d.tot_grootte_mb "表空间大小(M)",       d.tot_grootte_mb - f.total_bytes "已使用空间(M)",       to_char(round((d.tot_grootte_mb - f.total_bytes) / d.tot_grootte_mb * 100,                     2),               '990.99') || '%' "使用比",       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 1