Re: What is an Active Session from the EM console point of view ?
From: pitufo <vandresv_at_gmail.com>
Date: Mon, 10 Aug 2009 04:43:03 -0700 (PDT)
Message-ID: <25607cad-ca73-4c84-bb7e-30d63c8a11ab_at_g19g2000vbi.googlegroups.com>
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
Date: Mon, 10 Aug 2009 04:43:03 -0700 (PDT)
Message-ID: <25607cad-ca73-4c84-bb7e-30d63c8a11ab_at_g19g2000vbi.googlegroups.com>
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
Received on Mon Aug 10 2009 - 06:43:03 CDT