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

What is the difference between count (*), count (expression), count (distinct expression)?

What is the difference between column level constraints and table level constraints?

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

How to restrict the duplicate records in table valuesets

what is port in oracle? how is it related to database application.

Is truncate autocommit in oracle?

How to declare a local variable?

What are the various types of snapshots ?

How to define a variable to match a table column data type?

How many types of cluster table in Oracle?

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

How to create id with auto_increment on oracle?

For more Oracle General Interview Questions Click Here