檢視資料庫大小的通用命令:

一個新的資料庫,exp出來才90多M,看了一下資料庫大小,1.9G.

[@more@]

SQL> conn sys/**** as sysdba;
已連線。
SQL> SELECT A.DF "Data Files Size in MB"
2 ,B.TF "Temp Files Size in MB"
3 ,C.LF "Log Files Size in MB"
4 ,A.DF+B.TF+C.LF "Total Size"
5 FROM (SELECT SUM(BYTES/(1024*1024)) DF
6 FROM DBA_DATA_FILES ) A,
7 (SELECT SUM(BYTES/(1024*1024)) TF
8 FROM DBA_TEMP_FILES ) B,
9 (SELECT SUM(BYTES/(1024*1024)) LF
10 FROM V$LOG ) C;

Data Files Size in MB Temp Files Size in MB Log Files Size in MB Total Size
--------------------- --------------------- -------------------- ----------
1840 24 30 1894

SQL>