Number of sessions
From: suri <suriawan.limantara_at_googlemail.com>
Date: Fri, 1 Feb 2008 06:43:17 -0800 (PST)
Message-ID: <df22c5b9-c27a-44af-9c62-ff5995147e02@e25g2000prg.googlegroups.com>
Date: Fri, 1 Feb 2008 06:43:17 -0800 (PST)
Message-ID: <df22c5b9-c27a-44af-9c62-ff5995147e02@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
Received on Fri Feb 01 2008 - 08:43:17 CST