Re: How to check number of Concurrent session from AWR
From: Andy Klock <andy_at_oracledepot.com>
Date: Mon, 28 Oct 2013 17:08:23 -0400
Message-ID: <CADo_RaMTZAE52EBTXF6qgPOPfgD4n-CyCn6-hrecLMpb=zyNkQ_at_mail.gmail.com>
On Mon, Oct 28, 2013 at 4:27 PM, Jared Still <jkstill_at_gmail.com> wrote:
> Hi Sanjay,
>
> I think the question needs a little more explanation of what are really
> trying to accomplish.
>
Date: Mon, 28 Oct 2013 17:08:23 -0400
Message-ID: <CADo_RaMTZAE52EBTXF6qgPOPfgD4n-CyCn6-hrecLMpb=zyNkQ_at_mail.gmail.com>
On Mon, Oct 28, 2013 at 4:27 PM, Jared Still <jkstill_at_gmail.com> wrote:
> Hi Sanjay,
>
> I think the question needs a little more explanation of what are really
> trying to accomplish.
>
Agreed. AWR shows the number of sessions that are currently open at the end of the snapshot interval, via "logons current" in v$sysstat (See DBA_HIST_SYSTAT). And as Jared mentioned, ASH only shows data for sessions that are actually active. If auditing is enabled for connections perhaps you could mine DBA_AUDIT_SESSION, but if this is really required it may be easier to roll your own solution by sampling "logons current" more frequently than the AWR interval.
Andy
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 28 2013 - 22:08:23 CET