How to find out the Size of the Oracle Database (Any Versions 10g, 11g)


Col DBFSizeGB for 99999.99

Col TMPFSizeGB for 99999.99

Col LOGFSizeMB for 99999.99

Col CTRLSizeGB for 99999.99

Col TotalSIzeGB for 99999.99

 

select DBFSizeGB, TMPFSizeGB, LOGFSizeMb, CTRLSizeMB, DBFSizeGB+TMPFSizeGB+LOGFSizeMb/1024+CTRLSizeMB/1024 TotalSIzeGB

from

( select sum(bytes)/1024/1024/1024 DBFSizeGB from dba_data_files ) ,

( select nvl(sum(bytes),0)/1024/1024/1024 TMPFSizeGB from dba_temp_files )  ,

( select sum(bytes)/1024/1024 LOGFSizeMB from sys.v_$log )  ,

( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024 CTRLSizeMB from v$controlfile)

 

DBFSIZEGB TMPFSIZEGB LOGFSIZEMB CTRLSIZEMB TOTALSIZEGB

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

     2.13        .06     300.00      18.75        2.50

 

To find out Total Objects used Space

 

col ObjUsedSpace for 99999.99

select sum(bytes)/1024/1024/1024 ObjUsedSpace from dba_segments;

 

SQL> /

 

OBJUSEDSPACE

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

        1.32
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google