Re: Number of sessions
Date: Fri, 1 Feb 2008 07:30:34 -0800 (PST)
On 1 Feb., 16:00, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> suri <suriawan.limant..._at_googlemail.com> wrote in news:df22c5b9-c27a-44af-
> > Hi,
> > I am monitoring an Oracle 220.127.116.11 DB and fetch statspack report for
> > the same period every day. At one particular
> > day the number of Oracle sessions are much higher than the other days
> > and also the wait events are getting worst
> > at that day. Now I would like to know which additional users had
> > created extra sessions for that day. Where can
> > I get this kind of information? The statspack report itself does not
> > show the number of sessions opened by
> > each user.
> > Thanks.
> > Regards,
> > Suri
Isn't it so, that V$SESSION shows only the current running session? or it contains the sessions, that are ever connected since DB startup?
Suriawan Received on Fri Feb 01 2008 - 09:30:34 CST