?

oralce? 表空間查詢(xún)

SQL> select a.tablespace_name,a.bytes / 1024 / 1024 "sum MB",(a.bytes - b.bytes) / 1024 / 1024 "used MB",b.bytes / 1024 / 1024 "free MB",round(((a.bytes - b.bytes) / a.bytes) * 100, 2) "used%"from (select tablespace_name, sum( 2 3 4 5 6 bytes) bytesfrom dba_data_filesgroup by tablespace_name) a,(select tablespace_name, sum(bytes) bytes, max(bytes) largestfrom dba_free_spacegroup by tablespace_name) bwhere a.tablespace_name = b.tablespace 7 8 9 10 11 12 _nameorder by ((a.bytes - b.bytes) / a.bytes) desc; 13 TABLESPACE_NAME sum MB used MB free MB used% ------------------------------ ---------- ---------- ---------- ---------- SUNTEK 358955 260975.813 97979.1875 72.7 SYSAUX 73727 47873.5625 25853.4375 64.93 SYSTEM 65534 42442.5 23091.5 64.76 NEW12345 10240 5115.5 5124.5 49.96 XIAN12345 10240 3599.625 6640.375 35.15 PETRA 10240 2792.875 7447.125 27.27 UNDOTBS1 32767.9844 4322.10938 28445.875 13.19 UNDOTBS2 32767 2798.375 29968.625 8.54 USERS 100 1.3125 98.6875 1.319 rows selected.

?

總結(jié)

以上是生活随笔為你收集整理的Oracle表空间查询及扩充表空间的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。