This Blog provide you the knowledge regarding DBMS and RDBMS.Specially for SQL SERVER and Oracle.
Thanks A Lot .......for your cooperation and support.
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