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

After using set unused can we enable the column again to use? Please give me some answers....

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

What are the differences between char and varchar2 in oracle?

What is the difference between postgresql and oracle?

Explain the blob datatype?

How to start instance with a minimal initialization parameter file?

What is format trigger?

Can you tell me how to add new column in existing views?how?How is possible?

Can we connect to ORACLE db using Windows Authentication?

What is a table index?

What is user managed backup in Oracle?

How to define an anonymous procedure with variables?

For more Oracle General Interview Questions Click Here