Oracle Long Running Query

DESCRIPTION

This alert is for Oracle instances only and will tell you when SQL statements are currently running and have been for more than the defined amount of time. For example, if you want to catch any session that runs a query for more than 5 minutes, set your Min threshold to 300 seconds and leave the Max empty meaning anything higher. Also, set the execution interval to 5 minutes or less.

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 in the attached query.