Re: Number of sessions
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 01 Feb 2008 15:00:32 GMT
Message-ID: <kuGoj.41494$Wt7.37474@newsfe14.phx>
Date: Fri, 01 Feb 2008 15:00:32 GMT
Message-ID: <kuGoj.41494$Wt7.37474@newsfe14.phx>
suri <suriawan.limantara_at_googlemail.com> wrote in news:df22c5b9-c27a-44af-
9c62-ff5995147e02_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 Received on Fri Feb 01 2008 - 09:00:32 CST