Summary
Using SiteScope for +ASM diskgroup monitoring
Question
How can the freespace percentage of ASM diskgroup be monitored using SiteScope?
Answer
Recommendation is to create and use a Custom Database monitor since the metrics that you need to monitor are not currently supported:
On the below link you’ll find the counters available for the Oracle Database Monitor and the permissions required:
Oracle Database Monitor
https://docs.microfocus.com/itom/SiteScope:2018.05/Use/MR_Oracle_DB_Mon
https://docs.microfocus.com/itom/SiteScope:2018.05/Use/MR_Oracle_DB_Mon
You’ll find additional counters on the previous link.
Custom Database monitor information:
https://docs.microfocus.com/itom/SiteScope:2018.05/Use/MR_Custom_Database_Mon#.24filename.7C
Additional, seems like you’ll need permission to the below table if you’ll monitor ASM diskgroup.
V$ASM_DISK
DB reference: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170
DB reference: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1019.htm#REFRN30170
External links with additional information that you can use to determine the best implementation to monitor the ASM diskgroup:
Useful ASM scripts and queries: https://ronnyegner.wordpress.com/2009/10/07/useful-asm-scripts-and-queries/
Scripts to monitoring the Oracle ASM disks, files and volumes: https://labite.wordpress.com/2012/10/24/scripts-to-monitore-oracle-asm-disks/
How to monitor space usage on ASM diskgroups: https://dba.stackexchange.com/questions/36160/how-to-monitor-space-usage-on-asm-diskgroups