Quick SQL to determine your Database size. (excluding tempfiles)
SQL> select DF.TOTAL/1048576 “DataFile Size Mb”,
2 LOG.TOTAL/1048576 “Redo Log Size Mb”,
3 CONTROL.TOTAL/1048576 “Control File Size Mb”,
4 (DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 “Total Size Mb” from dual,
5 (select sum(a.bytes) TOTAL from dba_data_files a) DF,
6 (select sum(b.bytes) TOTAL from v$log b) LOG,
7 (select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;
Posted: June 30th, 2009 under Oracle Scripts.
Tags: determine oracle db size