oracle 11g表空间使用统计

select tablespace_name, round(used_space*( select value from v$parameter where name= 'db_block_size' )/power( 2 , 30 ), 2 ) USED_GB, round(tablespace_size*( select value from v$parameter where name= 'db_block_size' )/power( 2 , 30 )) MAXSIZE_GB, round(used_percent, 2 ) as "PCT%" from dba_tablespace_usage_metrics;

原贴在：http://blog.csdn.net/magic5650/article/details/50637517

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22569416/viewspace-2119475/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22569416/viewspace-2119475/