1 of 1 people found this helpful
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.
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
, ROUND((1- (free_mb / total_mb))*100, 2) pct_used
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!