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

How to loop through data rows in the implicit cursor?

1120

Explain rename?

1046

How to rename a column in an existing table?

1085

Explain enable novalidate constraint.

1132

State the difference between a primary key and foreign key?

998

What is an oracle database?

1111

What is an oracle table?

1034

candidate key is subset of super key but not vice-verse explain

2108

What are a query and state the different types of queries and their uses?

1066

What do you mean by merge in oracle?

1030

What are internal user account in oracle?

1055

How to invoke the original export import utilities?

1135

How can we find out the current date and time in oracle?

1132

What are the different types of trigger and explain its various uses and functions?

1169

what is the dual table in oracle?

1040