查看表空间使用情况 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
Link URL: http://lwhjava.itpub.net/post/43533/528391
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15483376/viewspace-739795/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15483376/viewspace-739795/