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 an oracle table?

567

What are the different types of modules in oracle forms?

566

What do you mean by redo log file mirroring?

565

What privilege is needed for a user to query tables in another schema?

513

How do I spool in oracle?

548

What is an oracle data file?

619

How to rename an index in oracle?

624

How to use in conditions in oracle?

567

List the various oracle database objects?

605

What the is the diff between local index and global index. give some example.

1140

Explain the importance of .pll extension in oracle?

561

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1628

How to use "in" parameter properly?

623

How to get a create statement for an existing table?

577

What is a table in oracle?

547