一个新的数据库,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博客 ” ，链接：https://blog.itpub.net/668365/viewspace-997695/ ，如需转载，请注明出处，否则将追究法律责任。
