Re: Users Waiting - What resource are they waiting on

V$SESSION_WAIT contains an EVENT column which lists the events for which active sessions are waiting.
Whenever an Oracle session is not actually using CPU resources, it will usually be in one of a number of wait events. For example, a session may be waiting for some I/O requests for db files (db file waits) or log files, to obtain the lock (enques waits), for free space in the SGA or for latches.

The wait event "SQL*Net message from client" indicates that the foreground user process is waiting on a message from a client and usually should be ignored. Also, you can ignore "timer" events and other SQL*Net messages.

Regards,
Tanya
--
Tanya Injac
Oracle Developer/DBA
Unisys NZ

Rob Rebmann <rob.rebmann_at_londonlife.com> wrote in article <01bd7902$1e7cc1f0$891c65cc_at_ll55049-c1>...
> I am running Oracle's Performance Manager and am listing # of active
users,
> # of user waiting and # of users waiting for locks.
> I typically have between 8 to 12 active users and 10 to 15 users waiting,
> with 0 users waiting for locks. How can I determine what resource they
are
> waiting on.
> I'm running Oracle 7.2.3 on an RS6000.J50 AIX 4.2 environement. Basically
> an OLTP environment.
>
> You can respond to rob.rebmann_at_londonlife.com
> --
> London Life Insurance rob.rebmann_at_londonlife.com
>
Received on Wed May 06 1998 - 23:15:43 CDT