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

how to find full database size

Question Posted / sudipta santra

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2095

What is object data modeling?

907

Explain the difference between a procedure and a function?

1091

Are truncate and delete commands same? If so why?

1081

How to execute the package in oracle?

1039

What is blob datatype?

1056

What is an oracle data file?

1039

master table and child table performances and comparisons in Oracle ?

2071

Explain the use of indexes option in imp command.

1088

How is it different from a normal table?

969

Where is the export dump file located?

1082

Explain index?

1205

Explain the use of tables option in exp command.

1054

What are the varoius components of physical database structure of oracle database?

946

Explain alias?

1081