資料檔案是否是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