Checks Oracle databases to ensure availability.
This event monitor checks your Oracle database servers. It can make sure the database server is available and can run SQL queries checking the results for specified values.
This event monitor provides the following options:
Use this option to get alerts if FrameFlow could not contact the selected database.
Enter the TNS name that you defined for your database. The event monitor will use this value to connect to your database.
Enable this option if you want to run a SQL statement or stored procedure on the database. The event monitor includes various options to check the results.
Enter the SQL statements that will run on the database. It's usually a good idea to verify the SQL code in Oracle itself before pasting it into the Oracle Event Monitor.
With this option enabled, the events and alerts generated by the event monitor will include rows returned by the SQL statement.
Enable this option to tell the event monitor to check the rows returned by the SQL statement. Further options allow you to specify what to search for. Enter an asterisk in the "Rows" field to select all rows.
Enter the text that the event monitor should look for.
Tells the event monitor how many result rows it should check for the specified text.
Tells the event monitor in which column it should look for the specified text.
Select an authentication profile with credentials that have access to the database being monitored.
The data points generated by this event monitor depend on the values you choose to monitor.
To view the tutorial for this event monitor, click here.
Add a comment