oracle中查看表空间使用情况
摘要:
--sqlselect dbf.tablespace_name,dbf.totalspace "总量(M)",dbf.totalblocks as 总块数,dfs.freespace "剩余总量(M)",dfs.freeblocks "剩余块数",(dfs.freespace / dbf.totalspace) * 100 "空闲比例"from (select t.tablespace_name,sum(t.bytes) / 1024 / 1024 totalspace,sum(t.blocks) totalblo 阅读全文
posted @ 2011-04-18 09:54 yaya's Space 阅读(3864) 评论(0) 推荐(0) 编辑