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 query image?

1022

How to rename a tablespace in oracle?

1123

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1917

Describe varray?

1113

How to test null values?

1152

what is meant by magic query

2230

How to handle a single quote in oracle sql?

1096

What are the differences between char and varchar2 in oracle?

1242

Differentiate between pre-select and pre-query?

1150

definition of cluster and non-clustered index?

3097

How to change system global area (sga) in oracle?

1062

Explain the use of indexes option in exp command.

1205

How to count groups returned with the group by clause in oracle?

1118

What is an oracle recycle bin?

1059

How to convert characters to times in oracle?

1070