Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Alert - Percent of Sessions Used


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 with values similar to these:

Alert Name: Percent of Sessions Used

Execution Interval: 10 Minutes

Notification Text: You are getting close to running into the maximum allowed sessions (SESSIONS parameter).

SQL Statement:

select 100 * num_sessions / max_sessions pct_sessions_used

from (

   select p.value max_sessions, count(1) num_sessions

   from v$session s, v$parameter p


   group by p.value)

Execute Against: Monitored Instance

Units: Session Usage %

High Threshold: Min 90, Max empty

Medium Threshold: Min 80, Max 90

Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎01-08-2014 07:46 AM
Updated by: