cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

How to create a custom SQL blocking alert for Oracle

I wanted to create a custom alerting for Oracle database servers. Currently it's being monitored manually on the server itself via a cronjob using a query such as below:

select
blocking_session,
sid,
serial#,
wait_class,
seconds_in_wait,
state
from
v$session
where
blocking_session is not NULL
order by
blocking_session;

 

How do I create this alert in SolarWinds for me to alert me when there's a blocking happens in the DB?

Labels (1)
0 Kudos
1 Reply
Level 13

When you create a SQL or Oracle query in orion, the result has to be once single value, and that value has to be an integer.

In your case, I suggest the query is changed so that it counts how many blocking sessions there is. Then you have a critical-threshold on the component in SAM, maybe when nr of blocking is more than 0 for x polls in a row.

Then, when monitoring is up, you can have an alert created.

0 Kudos