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 does one get the view definition of fixed views/tables?

1021

What is the difference between postgresql and oracle?

1048

what is the dual table in oracle?

992

What is connection pool in oracle?

988

How do I call oracle stored procedures that take no parameters?

1116

How to get execution statistics reports on query statements?

1094

What happens if you lost a data file?

1035

What is data type in oracle?

1125

How to change user password in oracle?

1029

What is the disadvantage of User defind function?

2293

what happened to the global index when I truncate the data in one of the partition?

2022

What is oracle join syntax?

1003

What is Data Dictionary Cache in Oracle?

1164

How to experiment a data lock in oracle?

1056

What is a select query statement in oracle?

968