Shulou(Shulou.com)06/01 Report--

Sum (remainedM) residual space M

Sum (usedM) / sum (totalM) * 100% occupancy

Sum (remainedM) / sum (totalM) * 100 remaining percentage

From (

Select b.file_id ID

B.tablespace_name tbs

B.file_name name,b.bytes/ (1024024) totalM

(b.bytes-sum (nvl (a.bytesre0) / (1024024) usedM

Sum (nvl (a.bytesre0)) / 1024 take 1024 remainedM

Sum (nvl (a.bytesd0)) / (b.bytes) * 100 remaining percentage

(100-(sum (nvl (a.bytesd0)) / (b.bytes) * 100)) percentage occupied

From dba_free_space a,dba_data_files b where a.file_id=b.file_id group by

B.tablespaceplayname group by b.fileroomnameauthorb.fileroomidbookb.bytes order by b.tablespace_name)

Tbs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.