Oracle性能调优：Oracle数据库表空间容量调整

--1、获取需要释放空间的表空间信息（包含oracle database自有表空间）

    --drop table system.tbs_detail;

    create table system.tbs_detail as select

    a.tablespace_name,

    a.bytes/1024/1024 "Sum_MB",

    (a.bytes-b.bytes)/1024/1024 "used_MB",

    b.bytes/1024/1024 "free_MB",

    round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used"   

    from

    (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a,    

    (select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name) b    

    where a.tablespace_name=b.tablespace_name    

    order by ((a.bytes-b.bytes)/a.bytes) desc;

    --select * from system.tbs_detail order by "Sum_MB" desc,"free_MB" desc;

    --2、获取需要释放空间的应用表空间数据文件使用情况

    --drop table system.datafile_space;

    create table system.datafile_space as 

    select a.TABLESPACE_NAME,

           a.FILE_NAME,

           a.BYTES / 1024 / 1024 total,

           b.sum_free / 1024 / 1024 free

      from dba_data_files a,