Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Oracle query monitoring, any way to handle an array?

In our environment we are looking for a way to have Solarwinds monitor a status for a number of customers from our Oracle Database. Is there any way to handle the return of a string instead of a statistic or even more useful to return a list similar to the Orion UNDP pollers, where I can have a customer name an a single statistic value, then alert off of those values. Below is an example result from the monitoring query.

NAME1 0
NAME2 0
NAME3 1
NAME4 0

In this return we would like to be able to alert on the "Name3" customer and return the statistic of 1. Today we would have to setup a couple hundred application pollers modifying each Query to include the customer name just to return the statistic.

Any Ideas?

-David

Find more posts tagged with

Accepted answers

jiri.tomek

Hello David,
I understand what you want to do but unfortunately Oracle or SQL UX monitor are not designed to allow this now.

You can try to achieve this by using custom script that would execute query, collect data and lookup values that you need to alert on. Then it can return those values in statistics and message fields.

All comments

jiri.tomek

Hello David,
current Oracle monitor expects only one numeric value as a result of query sou your scenario is not supported. Can you please explain more what exactly are you trying to do? How do you need to process example array you provided? How alerts should be set, what values do you want in reports etc?

freak523

We are looking for a way to monitor data and file movement on our backend databases for each of our customers to replace our older script/trap based monitoring. We have a number of database queries (Oracle & SQL) that will query the status of some process or data condition in our database then return a list of customers (text) and a status or count (numeric) back. Some queries return a couple different numeric values for each customer. Depending on what the value represents (a count of items (int) or a status (bool)) we want to be able to alert on those values, both visually within solarwinds as well as an alert (Email or SMS) going out with the customer name and the value.

Today if we want to accomplish this we would have to setup a single query for each customer for each value that we want to extract, since our customer list gradually changes it would be un-manageable to do it this way. If we had a simple way to just return the list of customers and a single value for each customer then have the ability to alert of any row within that list it would allow us to setup alerting for each app or data condition that we have without having to manage the list of customers. Being able to use that customer name (4 letter code) as a lookup key in our reports would allow us to link up all our different poller values into a single report as well.

-David

jiri.tomek

Hello David,
I understand what you want to do but unfortunately Oracle or SQL UX monitor are not designed to allow this now.

derik.pfeffer

Hello,

I know there has been many improvements and releases to Orion APM since this posting and wanted to know if there is a way to pull a string vs. a statistic. We are looking to see if a DB is in Open status using a Query of "select status from v$instance"

Derik