查看表空间使用率及shrink 表空间
摘要:
首先,可以通过下面的sql statement来查看表空间的使用情况。注意,该语句是在10g下测试过。SELECT FREE.TABLESPACE_NAME, FREE.FREE_SPACE/TOTAL.TOTAL_SPACE FROM (select TABLESPACE_NAME,sum(bytes)/1024/1024 AS FREE_SPACE from dba_free_space group by TABLESPACE_NAME) FREE, (select TABLESPACE_NAME,sum(BYTES)/1024/1024 AS TOTAL_SPACE from dba_. 阅读全文
posted @ 2013-07-03 13:42 kramer 阅读(629) 评论(0) 推荐(0) 编辑