USERS parameters

The parameters contained in the USERS category shows how many users are active and how many resources those users are using.

Related topic

The following table lists a brief description of each parameter.

USERS parameters


Parameter

Description

ActiveCalls

Reports the number of users with a call to the server currently in process. If this number is too high, examine the server's performance, the network's performance, or consider redistributing the users to use different servers.

IDsInUse

Rreports the number of SIDs that are currently connected to the database. If this number is too high, you may want to terminate some user sessions.

ProblemUsers

Reports the session detail for each problem user discovered during the current polling interval. A problem user is defined as a session that is:

  • waiting too long for a lock (BLOCKED or BLOCKEE)
  • using too much CPU as a percentage (CPUHOG)
  • blocking other users by holding a lock (BLOCKER)
  • doing nothing (IDLE)
  • running too long without returning any data (RUNAWAY)

Users

Reports the total number of user sessions that are currently running.

Was this page helpful? Yes No Submitting... Thank you

Comments