Description
This alert will run against the monitored Oracle databases and retrieve the time a session has been waiting ("Seconds Blocked" column) on a blocking session. It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from v$session.
Note that DPA also has a standard blocking alert located in the Alerts under Wait Time alerts. The difference in the base alert is that it goes after total locking time, vs the seconds each session has been blocked.
ALERT DEFINITION
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert as needed and paste the attached query into the Query section.
