Metrics for Oracle ASM Disk Space

There may be a couple of limitations with this request:

• We are connected to the Oracle instance being monitored, not the ASM instance
• We can currently plot a custom metric for one value at a time

Given these limitations, can you query the v$asm_diskgroup view from the monitored instance? If yes, we should be able to pull some data that can be summed (aggregated). Or, you may have to setup a metric for each diskgroup to show used space.

Thoughts?

Yes, I currently have alert set up using the query below to show % used. It alerts us at 95%. Would just be great to see a status check anytime we wanted

SELECT

    name                                     group_name

  , ROUND((1- (free_mb / total_mb))*100, 2)  pct_used

FROM

    v$asm_diskgroup

ORDER BY

    name

Our main groups are pretty standard. Should +DATA and +FRA. So if we need to set u pa metric for each of those that might work.

With that said, is there a way to put 'ASM' as one of the columns on the main DPA page to show warnings / errors? Would rather have it in that group then in Disk resources.

Unfortunately at this time, there's no way to customize the dashboard to add another column... Great feature request though!