HOW TO CHECK DATABASE SIZE IN ORACLE DATABASE

In this blog i am going to showing to everyone how we can easily check the whole database size in oracle using simple SQL queries there are different ways to calculates the database size and showing to user what is the exact size of db’s.

In the first ways you can check the database size using the below queries.

SQL> select round(sum(used.bytes)/1024/1024) "Database size in MB"

  

2from (select bytes from V$datafile

  

3  Union all

  

4  select bytes from V$tempfile

  

5  union all

  

6  select sum(block_size*file_size_blks)bytes from V$controlfile 

  

7  union all

  8  select bytes from V$log)used;

Database size in MB

-------------------

      

 2208