Database size in GB
Hi All,
I am executing following select to find db size.
I want this to be displayed on GB.
SQL> select sum(a) from
2 ( select sum(bytes) a from dba_data_files
3 union all
4 select sum(bytes) b from dba_temp_files
5 ) c
6 ;
SUM(A)
----------
1.3012E+11
SQL> select sum(a)/1024 from ( select sum(bytes) a from dba_data_files union all
2 select sum(bytes) b from dba_temp_files ) c ;
SUM(A)/1024
-----------
127071656
This figures in GB come to how much.