1. Home
  2. Feature Documentation
  3. Service Checks
  4. Check Oracle DB by Query (Service Check)

Check Oracle DB by Query (Service Check)

Object Type: Service Check

Service Check Category: Network Connectivity Checks

Passive: No

Description: Sends a specific, user-provided SQL query to an Oracle server and checks the response. This check is intended to use only queries that return one value (or one column), as it will only use the last column to filter on the output.

For example SELECT root_id, related_devices_id FROM root WHERE root_id = 3 would only use the comparator against the related_devices_id column. Although it won’t crash if you specify multiple columns, the query should really only retrieve 1 column at a time. In the previous example it will just do nothing with the root_id column.

A query like SELECT root_id FROM root is also not really useful as it will grab the first row in root and the last column of the table.

A better query would be something like SELECT count(*) from root since it returns only one value.

What’s important to understand about this check is that it’s only expecting one column from the table to compare with. If it’s given more than one row and more than one column, it will use the first row and last column returned.

Check-specific Fields:
(See Service Check for details on basic configuration options.)

  • COMMAND
    (Required) The SQL query run against the Oracle database.
  • COMPARATOR
    (Required) The logical operator by which to evaluate the value returned by the query. Acceptable values are:

    • ==
    • >=
    • <=
    • !=
    • =~ (for regex)
    • !~ (for inverse regex)
  • VALUE
    (Required) The value to which the value returned by the query will be compared. Must be numeric when using the ==, >=, <= or != comparators. Can be any regex value when using the =~ or !~ comparators.
  • DESCRIPTION
    (Required) This field specifies a name for this check. The name entered must be unique among service check names on the host it is added to (the name may used again only on a different host). It is used to identify this specific check from among other service checks added to the same host.
Updated on April 27, 2021

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Reply