Re: How to check number of Concurrent session from AWR
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Sanjay Mishra <smishra_97@xxxxxxxxx>
- Date: Mon, 28 Oct 2013 13:27:03 -0700
On Mon, Oct 28, 2013 at 12:48 PM, Sanjay Mishra <smishra_97@xxxxxxxxx>wrote:
> What is best way to check max number of concurrent session reported in a
> specific AWR snapshot. Need to check number of concurrent session at some
> outage time and so need to compare if the number of concurrent session
> reported in any snapshot are drammatically high then other
>
Hi Sanjay,
I think the question needs a little more explanation of what are really
trying to accomplish.
By default an AWR snapshot is 60 minutes.
During that time a session may appear several times, or not at all,
The data stored in AWR is 10% of what is seen in ASH,
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
