Oracle Max Sessions

DESCRIPTION

This alert calculates the percent of sessions used, i.e. the number of current sessions divided by the maximum allowed sessions (SESSIONS 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.