« 无文件备份、拥有所有归档的恢复 | Blog首页 | 丢失所有文件、拥有全备份,缺少后增加的文件 »
Oracle HowTo:如何查看各个表空间的自由空间
作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2004/10/get_free_space.html
DBA_FREE_SPACE视图记录了数据库中所有表空间的自由extents情况，所以可以从该视图获得各表空间自由空间情况。
SQL> desc dba_free_space Name Null? Type ----------------------- ------------- ----------------- TABLESPACE_NAME VARCHAR2(30) FILE_ID NUMBER BLOCK_ID NUMBER BYTES NUMBER BLOCKS NUMBER RELATIVE_FNO NUMBER |
可以使用如下SQL进行查询:
select tablespace_name,sum(bytes)/1024/1024 free_Mbytes from dba_free_space group by tablespace_name order by free_Mbytes / |
示例输出:
SQL> select tablespace_name,sum(bytes)/1024/1024 free_Mbytes 2 from dba_free_space 3 group by tablespace_name 4 order by free_Mbytes 5 / TABLESPACE_NAME FREE_MBYTES -------------------- ----------- USERS .75 UNDOTBS1 18.6875 SYSTEM 42.6875 |
By eygle on 2004-10-14 09:55 | Comments (0) | Posted to HowTo | Scripts | Edit |Pageviews:
网上相关主题:
