Check Database Size

From NazimWIKI
Jump to navigation Jump to search
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
        );