sumer77

 Profile Answers by sumer77 

• Oct 24th, 2008

 

1. Sum of the data files

select sum(bytes/1024/1024/1024) 'Size in GB' from dba_data_files;

2. Actual data size:

select sum(bytes/1024/1024/1024) 'Size in GB' from DBA_segments;

vikashj

 Profile Answers by vikashj 

• Nov 22nd, 2008

 

in Addition you can also use:

select sum(bytes/1024/1024/1024) from dba_extents;

Reg,
Vikash

SURAJ BANSODE

• Oct 13th, 2016

 

To find the size of database we need to Sum (datafiles+redo log files+temp files+control files)

Caesar Dutta

• Nov 6th, 2017

 

Select sum(bytes) from dba_segments