select sum(bytes / (1024*1024)) "DB Size in MB" from dba_data

how to find full database size

Question Posted / sudipta santra

Answer Posted / sudipta santra

select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;

If u have the access of the table dba_data_files

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is data block in Oracle?

1114

What are privileges and grants?

1063

Explain oracle’s system global area (sga).

1136

What is proxy method?

967

What is query image?

979

What is a trace file and how is it created in oracle?

1048

What is an oracle user account?

984

What is the relation of a user account and a schema in oracle?

1080

How to create a temporary table in oracle?

1264

What are a collation and state the different types of collation sensitivity?

1164

How to use "in" parameter properly?

1060

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2047

What are the attributes of cursor?

1046

How to assign values to data fields in record variables?

1029

What is system global area (sga) in oracle?

989