Friday, March 4, 2016

Exadata ASM usage

Here is the sql I used to get the ExaData ASM usage:

  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'


Since we have multiple databases in several of our ExaData machines, I will need to write a script to run this against all of our databases.



No comments:

Post a Comment