Skip navigation

ASM query for ASM Percent Occupied and ASM Assigned GB

score 35
You have not voted. Product Team Review

On TSCO 11.5 there are some metrics collected for ASM management, and some could be added to the pack.

 

Some Storage administrators find the following 2 very useful:

 

'ASM_PERCENT_OCU_C' AS OBJNAME,

round(100 - ((FREE_MB-REQUIRED_MIRROR_FREE_MB/TOTAL_MB)*100),1) AS VALUE

from v$asm_diskgroup

 

'ASM_ASSIGNED_GB_C' AS OBJNAME,

decode(type,'EXTERNAL',ceil(TOTAL_MB/1024),'NORMAL',ceil(TOTAL_MB/2/1024),ceil(TOTAL_MB/3/1024)) -

   decode(type,'EXTERNAL',ceil(FREE_MB/1024), 'NORMAL',ceil(FREE_MB/2/1024), ceil(FREE_MB/3/1024)) AS VALUE

from v$asm_diskgroup

 

The metric REQUIRED_MIRROR_FREE_MB seems available for ASM disk groups.

 

Attached you can see this metric:

Managing Capacity in Disk Groups

 

hopefully they can be added to the tool.

Comments

Vote history