You often need to know the size of an Oracle database to move it from one server to another. Or just to know if your export or whatever is going to take a lot of space and time.
In this article I show you a simple way to calculate the size of your Oracle database.
Size of Oracle datafiles in GB
select sum(bytes)/(1024*1024*1024) G
from dba_data_files;