Re: How to check number of Concurrent session from AWR

From: Andy Klock <>
Date: Mon, 28 Oct 2013 17:08:23 -0400
Message-ID: <>

On Mon, Oct 28, 2013 at 4:27 PM, Jared Still <> 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.


Received on Mon Oct 28 2013 - 22:08:23 CET

Original text of this message