Wednesday 24 April 2013

To check the total size of the database.

 To check the total size of the database.


sql>select sum(bytes/1024/1024/1024) geg from dba_segments;



       GEG
----------
8.84643555……to check the total size of the data..

OR



select sum(bytes / (1024*1024)) "DB Size in GB" from dba_data_files;

No comments:

Post a Comment