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

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google