select 'Exadata', round(TOTAL_MB/decode(type,''NORMAL'',2,''HIGH'',3,1)/1024) total_GB,
round(usable_FILE_mb/1024) usable_free_GB,
round((HOT_USED_MB+COLD_USED_MB)/decode(type,''NORMAL'',2,''HIGH'',3,1)/1024)
data_use_GB,
round(REQUIRED_MIRROR_FREE_MB/decode(type,''NORMAL'',2,''HIGH'',3,1)/1024)
Req_free_redun_GB,
ROUND(((HOT_USED_MB+COLD_USED_MB)/total_MB)*100) perc,sysdate
from v$asm_diskgroup where total_mb != 0'
No comments:
Post a Comment