Thursday 18 August 2011

How to find overall size of database and actual size of database in oracle

SQL>  select sum(bytes)/1024/1024/1024 "overall size in GB" from dba_data_files;

SQL> select  sum(bytes)/1024/1024/1024 "used space  size in GB" FROM dba_segments;

No comments:

Post a Comment