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 are the various constraints used in oracle?

988

What are the different editions of oracle?

1042

What are the types of trigger in oracle?

911

How to create a server parameter file?

1079

various types of hints and their usage

2622

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

2022

How would you go about verifying the network name that the local_listener is currently using?

1988

What is the difference between translate and replace in oracle?

1111

How to retrieve values from data fields in record variables?

1029

What is the difference between translate and replace?

1010

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2208

In which language oracle has been developed?

1013

Can we use bind variables in oracle stored procedure?

896

How can we force the database to use the user specified rollback segment?

1061

How to use "in out" parameter properly?

997