Re: Number of sessions

From: Ana C. Dent <>
Date: Fri, 01 Feb 2008 15:00:32 GMT
Message-ID: <kuGoj.41494$Wt7.37474@newsfe14.phx>

suri <> wrote in news:df22c5b9-c27a-44af-

> Hi,
> I am monitoring an Oracle 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 Received on Fri Feb 01 2008 - 09:00:32 CST

Original text of this message