Monitoring Services

Services represent groups 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.

Figure 4-7 Monitoring Services

Description of "Figure 4-7 Monitoring Services"

To monitor services:

1. Access the Database Home page.

   See "Accessing the Database Home Page" for more information.

2. From the Performance menu, select Performance Home.

   If the Database Login page appears, then log in as a user with administrator privileges. The Performance page appears.

3. In the instance activity chart, click Services.

   The Services chart appears. The Services chart shows services waiting for the corresponding wait event during the time period shown. Only active services are shown.

   In Figure 4-7, the SYS$USERS service has the greatest number of active sessions.

4. Click the largest colored area on the chart or the corresponding service in the legend to drill down to the service with the highest number of active sessions.

   The Service page appears, showing the Activity subpage.

   You can view real-time data showing the session load for all wait classes associated with the service.