Re: What is an Active Session from the EM console point of view ?
From: ddf <oratune_at_msn.com>
Date: Mon, 10 Aug 2009 06:03:22 -0700 (PDT)
Message-ID: <68f56709-0589-4fea-8d38-09af5dc0eb45_at_p15g2000vbl.googlegroups.com>
On Aug 10, 6:43 am, pitufo <vandr..._at_gmail.com> wrote:
> On Aug 7, 2:01 am, sybra..._at_hccnet.nl wrote:
>
>
>
>
>
> > On Thu, 6 Aug 2009 18:39:01 -0700 (PDT), pitufo <vandr..._at_gmail.com>
> > wrote:
>
> > >Hello,
> > >I am checking the output of EM console under Active Session in my
> > >database (rdbms 10.2.0.2) and I can see that it shows an average
> > >number of active session of less than 2 active users.
> > >Checking v$session (for about 15 minutes with 30 seconds between
> > >samples ) and there are about 20-21 session with STATUS='ACTIVE'.
>
> > >Any one has an idea why the discrepancy between both metrics ?
>
> > >Thank you very much,
> > >Andres
>
> > I don't think EM (or better still The Management Agent) checks for
> > active session that often. It is configurable though!
>
> > --
>
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Thanks for replying.
> I have it to refresh every 15 seconds (in the browser...if that's what
> configurable means of course) and it is not matching what v$session->status=active reports.
>
> Best regards,
> Andres- Hide quoted text -
>
> - Show quoted text -
Date: Mon, 10 Aug 2009 06:03:22 -0700 (PDT)
Message-ID: <68f56709-0589-4fea-8d38-09af5dc0eb45_at_p15g2000vbl.googlegroups.com>
On Aug 10, 6:43 am, pitufo <vandr..._at_gmail.com> wrote:
> On Aug 7, 2:01 am, sybra..._at_hccnet.nl wrote:
>
>
>
>
>
> > On Thu, 6 Aug 2009 18:39:01 -0700 (PDT), pitufo <vandr..._at_gmail.com>
> > wrote:
>
> > >Hello,
> > >I am checking the output of EM console under Active Session in my
> > >database (rdbms 10.2.0.2) and I can see that it shows an average
> > >number of active session of less than 2 active users.
> > >Checking v$session (for about 15 minutes with 30 seconds between
> > >samples ) and there are about 20-21 session with STATUS='ACTIVE'.
>
> > >Any one has an idea why the discrepancy between both metrics ?
>
> > >Thank you very much,
> > >Andres
>
> > I don't think EM (or better still The Management Agent) checks for
> > active session that often. It is configurable though!
>
> > --
>
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Thanks for replying.
> I have it to refresh every 15 seconds (in the browser...if that's what
> configurable means of course) and it is not matching what v$session->status=active reports.
>
> Best regards,
> Andres- Hide quoted text -
>
> - Show quoted text -
I expect that it won't as it's probably using V$ACTIVE_SESSION_HISTORY rather than V$SESSION and I suspect the criteria for determining ACTIVE sessions differs between the two views.
David Fitzjarrell Received on Mon Aug 10 2009 - 08:03:22 CDT