Shrikant Pande

• Aug 24th, 2005

 

select sum(bytes)/1024/1024/1024 Size_in_GB from dba_data_files;

rajat dey

• Feb 17th, 2006

 

select sum(bytes)/1024/1024 from v_$datafile

+

select sum(bytes)/1024/1024 from v_$logfile

will give u the total size of the database

samarem

 Profile Answers by samarem 

• Mar 10th, 2006

 

select (select sum(bytes/1024/1024/1024) from v$datafile) +( select sum(bytes/1024/1024/1024) from v$tempfile) + (select sum(bytes/1024/1024/1024) from v$log) "Size of Database in GB" from dual

Nitin Singhal

DBA(LGEIL)

Ravi Prakash Pichika

• Jun 20th, 2006

 

SQL>SELECT SUM(BYTES)/1024/1024 FROM DBA_DATA_FILES;

SQL>ed

1 SELECT a+b+c DBSIZE from

2 (SELECT SUM(BYTES)/1024/1024 a FROM DBA_TEMP_FILES),

3 (SELECT SUM(BYTES)/1024/1024 b FROM V$LOG),

4 (SELECT SUM(BYTES)/1024/1024 c FROM DBA_DATA_FILES)

SQL> /

DBSIZE

450444.43

cmanne

 Profile Answers by cmanne 

• Jul 29th, 2006

 

At oracle level query data files + tempfiles

At OS level use df -k or du -h

gvishalsoft

 Profile Answers by gvishalsoft 

• Apr 28th, 2009

 

select substr(to_char(sum(bytes)/1024/1024, '999,999,999.99'), 1, 15) "TOTALMB", substr(to_char(sum(bytes)/1024/1024/1024, '999,999.99'), 1, 11) "TOTALGB" from dba_data_files;

prasant singh

• Oct 3rd, 2017

 

Can you explain why using bytes/1024/1024/1024