Re: Number of sessions

On Fri, 1 Feb 2008 06:43:17 -0800 (PST), suri <suriawan.limantara_at_googlemail.com> wrote:

>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

Use database auditing to audit the connections. Received on Mon Feb 11 2008 - 15:26:01 CST