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 a data dictionary and how can it be created?

1151

What is tns service name?

1126

Explain the difference between a procedure and a function? What do you understand by those terms?

1085

How to use "if" statements on multiple conditions?

1174

What are the different types of synonyms?

1140

How do I call oracle stored procedures that take no parameters?

1116

How to use "in" parameter properly?

1071

can u plz provide me oca sql dumps please i need them

1949

Explain do view contain data?

1013

What is oracle analytical function?

1145

What are the differences between lov and list item?

1066

How to create a stored procedure in oracle?

1104

What are joins, explain all types of joins?

2299

How to get maxsal , minsal, ename department wise in single query

1549

What are the oracle built-in data types?

1074