Script To Check DB Size

Script To Check DB Size

SELECT SUM (bytes) / 1024 / 1024 / 1024 AS GB FROM dba_data_files;

select sum (bytes) /1024 /1024 /1024 from dba_data_files where tablespace_name not in ('UNDOTBS1');