Re: Number of sessions

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-
> 9c62-ff5995147..._at_e25g2000prg.googlegroups.com:
>
>
>
> > Hi,
>
> > I am monitoring an Oracle 9.2.0.8 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
>
> V$SESSION
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?

Thanks,
Suriawan Received on Fri Feb 01 2008 - 09:30:34 CST