how to find full database size

Question Posted / veeravel.csv@gmail.com

how to find full database size..

Answer / sudipta santra

select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;

If u have the access of the table dba_data_files

Is This Answer Correct ?

3 Yes

0 No

More Oracle General Interview Questions

Give the constructs of a package, function or a procedure.

How to login to the server without an instance?

What is the best way to do multi-row insert in oracle?

What is dual table oracle?

without using count(*) and rownum how can we count total record in a table

What are the set operators union, union all, minus & intersect meant to do?

Whatz the main diff between Subquery and a Join

What happens in oracle commit?

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

What is not equal to in oracle?

is database gud carrier option??

What happens to the data files if a tablespace is dropped?

For more Oracle General Interview Questions Click Here