Oracle Max Locks

Description

This alert will review the number of locks currently being used and compare to the max_locks parameter.

Alert Definition

To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return. Configure the alert as needed and paste in the attached query.