Database Query (Oracle)

The Oracle Query Check component allows you to create a query to run on a specific device to assess the health of an Oracle database. You may add an Oracle Query component to either an application profile or an application instance.

Configure the following for database components:

• Name. Enter a unique name for the component.
• Description. 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.
• Port. 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 SQL 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.