查询tablespace使用量与剩余空间以及table所占硬碟的大小

 

查询tablespace使用量：select tablespace_name,sum(bytes)/1024/1024 from dba_extents where tablespace_name='MIS_TABLESPACE' group by tablespace_name

查询tablespace剩余空间：select tablespace_name,round(sum(bytes)/1024/1024,2) "FREE_MB" from dba_free_space group by tablespace_name

查询table所占硬碟的大小：select table_name, blocks * (select value from v$parameter where name='db_block_size')/1024/1024 as size_mb from user_tables where table_name=TABLE_NAME