Monitoring Session Identifiers

The Average Active Sessions by drop-down contains a Sessions Identifiers fly-out with the following common views:

• Instance
• Service
• User Session
• Parallel Process
• User Name
• Program
• Session Type

A service is a group of applications with common attributes, service-level thresholds, and priorities. For example, the SYS$USERS service is the default service name used when a user session is established without explicitly identifying a service name. The SYS$BACKGROUND service consists of all database background processes. If a service is using the majority of the wait time, then you should investigate it.

A session is a logical entity in the database instance memory that represents the state of a current user login to the database. A session lasts from the time a user logs in to the database until the user disconnects. For example, when a user starts SQL*Plus, the user must provide a valid database user name and password to establish a session. If a single session is consuming the majority of database activity, then you should investigate it.

To monitor session identifiers:

1. Access the Performance Hub page, as explained in "Monitoring User Activity".

2. Click on the drop-down in Average Active Sessions by, mouse onto Session Identifiers, and select the desired view from the fly-out.

   • Instance
   • Service
   • User Session
   • Parallel Process
   • User Name
   • Program
   • Session Type

   Graphs, tables, and information on the page are updated to reflect the selected criteria.