Oracle Query monitor

Specify a name for the monitor instance. This is displayed on folders, graphs, lists, etc.

 Specify a tag value to search or group the objects. You can enter multiple name-value pairs, text, or include both (name-value pair and text). This gives you the option to group objects in different forms. Click the + icon to select a default tag class. The Enter Tag Details screen opens. Select Tag Class from the drop-down list and enter a tag value. Click Add to append tag class and value. Click Finish.

• Editing a Tag Value on the Enter Tag Details screen: Select a tag value and click Edit. Make the necessary modifications in the Tag Value text box and click Set to add the changes.
• Deleting a Tag Value on the Enter Tag Details screen: Select a tag value and click Delete. Click Yes to delete the tag value.

 Specify the query to execute on each poll. The query defines the SQL statement for monitor operations.  

This query should use a simple read-only SQL statement such as SELECT (example, select count (*) from dual) or UPDATE. Complex queries like Joins and PL/SQL are not supported. The monitor expects an integer value from this query, so it is best to cast the returned value as an integer using the COUNT statement. The maximum data value that can be stored for this monitor is 2^ 31-1.

You can also specify a file, which contains the SQL query using the following syntax:

 file: <filepath> (example, file:c:\temp\test.sql in Windows or file:/tmp/test.sql in UNIX).

Select/clear check box to enable/disable data collection for the monitored component. By default, data collection is enabled (check box selected).

Specify the number of consecutive unsuccessful attempts for recording Zero availability for the poll. Default is 3.

Specify the time interval between two consecutive attempts of a single poll. Default is 20 seconds.

Specify the time interval between two consecutive Statistical data polls. Default is 5 minutes.

Specify the time-out period for each poll of statistical data. If no data is available at the end of this interval, system records Zero availability and proceeds with the next scheduled poll. Default is 20 seconds.

This enables you to add a device and its monitors to one or more groups. Optionally, you may associate the device with a group. A group is used to logically organize the devices and monitors by department, geographic area, or service. Assigning a device to a group also enables the system administrator to restrict or allow access to certain devices. To associate the device with a group, select the group name here.

Monitors can be created even when the target application/device is not running. Agent must be upgraded to 7.1 for creation of monitor using skip validation. This monitor enables forceful creation when the monitored target is not reachable or specified inputs are wrong. Click Yes on the Skip Validation confirmation message to forcefully create a monitor. Clicking No will fail the monitor creation. Forcefully creating the monitor when target is not reachable or with invalid input(s) may cause Availability to be set to 0.