This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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?

  • 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.