Oracle Query component fields

You may configure the following boxes for the Oracle Query component:

• Name. Enter a unique name for the component.
• Description. (Optional) Enter additional information about the component.
• Critical. Click to select this check box if the component is critical.

  Note: Components specified as critical cause the application to go into a down state when the component is out of threshold. Non-critical components cause the application to go into a warning state. For more information on application states, see Working with application states.

• Polling frequency. Select a time (in minutes or hours) you want APM to wait between polls.
• Service name. Enter the ServiceName.
• Port (optional). Enter the database server port number if other than the standard database port number.
• Connection timeout. Enter the length of time APM attempts to connect to the selected device. When the time you enter is exceeded without connecting, a timeout occurs and APM stops trying to connect to the device. This is considered a failed connection.
• Query to Run. Enter a query you want to run against a database to monitor and check for certain database conditions. Only select queries are allowed.

  Important: Make sure that you include the full database name in your query.

• Warning threshold. Enter the component thresholds for the warning state. For example, if the component value is greater than 90 for 5 minutes, put the component in the warning state.
• Down threshold. Enter the component thresholds for the down state. For example, if the component value is greater than 95 for 5 minutes, put the component in the down state.