This document explains how to create and configure custom (new) checkpoints using the oracle probe.
Custom checkpoints allow you to use our own preferred queries for database monitoring when the default checkpoints provided do not satisfy your specific database monitoring requirements. This guide walks you through configuring and testing a custom checkpoint, configuring data collection (QoS), configuring alarms and alarm thresholds.
1. Open oracle probe GUI in Infrastructure Manager or Admin Console.
2. Go to “Templates” tab and right click on Open space and then click on “Create new” option.
3. Add the required name for the checkpoint to monitor
4. Query template editor will open as below.
5. Select “Active” and “Send Quality of Service” options. You can give the Check interval and other required fields as per the requirement.
6. Go to “Query” tab.
7. You can add the thresholds as per the requirement and values in the “Thresholds/Schedules” section.
8. Checkpoints gets added to the oracle probe.
9. Click on Apply and OK and then restart the probe.
How to change the threshold for specific checkpoint in a oracle probe
The query being used contained a TO_CHAR. The Oracle TO_CHAR() function converts a DATE or INTERVAL value to a string in a specified date format.
So that is why only character data type was available in the drop down window for selection. Once the query was changed to stop the conversion to string, the numeric Data type displayed and so did 'value.' Then we were able to create the proper thresholds and alarm messages, including a custom clear message.
To support the column names and data being collected in the query, in this particular case we changed the $NAME to $TSPACE and $USED_PCT to $USED_PCT1 respectively and then the oracle probe GUI Status window showed the proper tablespace names and percentage values. Row key identifier also has to be unique so we used the column $TSPACE (for the tablespace name) instead of USED_PCT1.
The customer also created a new unique clear message using the new variables and applied it.