Check Database Size

SELECT sum(megabytes) 
  FROM ( SELECT sum(bytes)/1024/1024 megabytes FROM dba_temp_files
          UNION
         SELECT sum(bytes)/1024/1024 megabytes FROM dba_data_files
          UNION
         SELECT sum(bytes)/1024/1024 megabytes FROM v$log
        );