SQL> desc dba_free_space Name Null? Type ----------------------- ------------- ----------------- TABLESPACE_NAME VARCHAR2(30) FILE_ID NUMBER BLOCK_ID NUMBER BYTES NUMBER BLOCKS NUMBER RELATIVE_FNO NUMBER
可以使用如下SQL進行查詢: select tablespace_name,sum(bytes)/1024/1024 free_Mbytes from dba_free_space group by tablespace_name order by free_Mbytes /
示例輸出: SQL> select tablespace_name,sum(bytes)/1024/1024 free_Mbytes 2 from dba_free_space 3 group by tablespace_name 4 order by free_Mbytes 5 /
TABLESPACE_NAME FREE_MBYTES -------------------- ----------- USERS .75 UNDOTBS1 18.6875 SYSTEM 42.6875
