数据文件是否是smallfile类型文件，其存储是否达到数据文件存储上限，是否是多个数据文件...

查看表空间使用情况 select a.tablespace_name ,ROUND(sum(b.bytes)/1024/1024) "total MB",round(sum(c.free)) "free MB",round(sum(b.bytes)/1024/1024-sum(c.free)) "use MB" ,round(case when min(a.bigfile)='NO' and min(a.segment_space_management)='AUTO' then min(a.block_size)*(power(2,22)-1)/1024/1024*count(b.NAME) when min(a.bigfile)='NO' and min(a.segment_space_management)='MANUAL' then sum(b.bytes)/1024/1024end) "maxsize MB",round(case when min(a.bigfile)='NO' and min(a.segment_space_management)='AU...

Link URL: http://lwhjava.itpub.net/post/43533/528391

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

转载于:http://blog.itpub.net/15483376/viewspace-739795/