Oracle Max Sessions


This alert calculates the percent of sessions used, i.e. the number of current sessions divided by the maximum allowed sessions (SESSIONS parameter).


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.