Re: How to check number of Concurrent session from AWR
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: Jared Still <jkstill@xxxxxxxxx>
- Date: Mon, 28 Oct 2013 17:08:23 -0400
On Mon, Oct 28, 2013 at 4:27 PM, Jared Still <jkstill@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
