advertisements
_____________________________________________________________________________________________________________________
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