Re: Number of sessions

From: Richard Piasecki <>
Date: 11 Feb 2008 15:26:01 -0600
Message-ID: <>

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

>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.

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

Original text of this message