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?