Home › Check Oracle database size with DBA_DATA_FILES and DBA_SEGMENTS

Check Oracle database size with DBA_DATA_FILES and DBA_SEGMENTS 

Dr. Xi
Joined:
04/09/2007
Posts:
710

February 04, 2010 00:21:05    Last update: February 04, 2010 00:22:09
The table DBA_DATA_FILES contains information about data files used in an Oracle database.

The table DBA_SEGMENTS describes the storage allocated for all segments in the database. 

SQL> select sum(bytes)/1024/1024 SIZE_MB from dba_data_files;

   SIZE_MB
----------
       905

SQL> select sum(bytes)/1024/1024 SIZE_MB from dba_segments;

   SIZE_MB
----------
   646.375

SQL>
Share |
| Comment  | Tags
 
Easy email testing with http://www.ximailstop.com