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

What is oracle datasource?

737

How to store only time; not date and time?

723

What is an oracle user account?

743

How to define an anonymous block?

815

How to use subqueries in the from clause in oracle?

806

What is an oracle and why it is used?

814

candidate key is subset of super key but not vice-verse explain

1766

What are the execution control statements?

807

How to start a new transaction in oracle?

793

What is an oracle tablespace?

769

What's dateware house and what's clustor with practicle example

1891

Explain what are clusters?

822

How data locks are respected in oracle?

790

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

751

What is a trigger oracle?

793