3.49 UserSessions

Use this Knowledge Script to monitor the total number of user sessions accessing an Oracle database. If the total number of user sessions crosses the threshold, the job raises an event.

You can specify the number of user sessions to display in the Event Properties dialog box. The Event Properties dialog box displays the total number of user sessions exceeding the threshold. Information in the graph includes the number of sessions for each user and the username.

The account you use to run this script must have SELECT permissions for the following tables:

DBA_USERS

V_$SESSION

3.49.1 Resource Objects

Oracle RDBMS Server icon, or Oracle RDBMS icon. When dropped on the Oracle RDBMS Server icon, a single script job monitors every database on that server. When dropped on an Oracle RDBMS icon, the script monitors only that database.

3.49.2 Default Schedule

The default interval for this script is Every 30 minutes.

3.49.3 Setting Parameter Values

Set the following parameters as needed:

Description	How to Set It
Oracle Username	Enter the username that this script needs to access the target databases. If you run this script on more than one database, configure each database with the same username. To use SYSDBA authentication, leave this parameter blank. The default is blank.
Collect data for number of user sessions?	Select Yes to collect data for charts and reports. When you enable data collection, the Knowledge Script returns the total number of user sessions. The default is unselected.
Number of user sessions to display	Specify the number of user sessions you want displayed in the Event Properties dialog box. Enter 0 if you want all user sessions displayed. The default is 10.
Raise event if threshold is exceeded?	Select Yes to raise an event if the number of user sessions exceeds the threshold.The default is unselected.
Threshold - Maximum total user sessions	Enter a threshold for maximum number of user sessions. The default is 75.
Severity	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).
Event severity for internal failure	Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).