Dear All,

Which Database size u want ?
Physical size or Actual size or Logical Size?

Total Size of Database :

Select sum(bytes)/1024/1024/1024 "Physical Database Size" ,' GB '
from dba_data_files ;


Actual Size of the database :

select sum(bytes)/1024/1024/1024 "Actual Database Size", ' GB '
from dba_segments ;


If u want to know the Logical size of the database , take full export of the database and check the size of the export dump file.


I hope my suggestion will help.....