查看数据库大小的通用命令:

一个新的数据库,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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/668365/viewspace-997695/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/668365/viewspace-997695/