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

How can we find the size of a database?

Question Posted / ammar takieddin

Answer Posted / ammar takieddin

select sum(bytes)/1024/1024 from dba_data_files;
+
select sum(bytes)/1024/1024 from v$log;

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1080

How can I create database in oracle?

1012

What is ordinary table in oracle?

1151

Explain the use of file option in exp command.

1127

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2493

What is the difference between pre-select and pre-query?

1210

Explain how are indexes update?

1060

What is an Oracle Instance?

1118

what are actual and formal parameters?

1104

How to insert a record into a table?

1066

How to define an explicit cursor in oracle?

1032

How would you begin to troubleshoot an ORA-3113 error?

2077

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1861

How to save query output to a local file?

1023

Explain what are the characteristics of data files?

1082