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 shutdown your 10g xe server?

618

How do we represent comments in oracle?

629

How to rollback the current transaction in oracle?

538

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

1604

What is a snapshot in oracle database?

578

What are the logical operations?

677

how the indexes are stored in the Oracle Database?

1740

How to use "while" statements in oracle?

737

How to insert a new row into a table in oracle?

591

How does the on-delete-cascade statement work?

608

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

556

What is recovery manager(rman) backup in Oracle?

629

How to specify default values in insert statement using oracle?

562

How to view the data files in the current database?

592

What are the different types of modules in oracle forms?

562