Re: How to check number of Concurrent session from AWR
From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 28 Oct 2013 13:27:03 -0700
Message-ID: <CAORjz=NkFPvxfJqnLzvZpAno_5_do=_FSxoF+c=Z4UT87AUr9Q_at_mail.gmail.com>
On Mon, Oct 28, 2013 at 12:48 PM, Sanjay Mishra <smishra_97_at_yahoo.com>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
>
Date: Mon, 28 Oct 2013 13:27:03 -0700
Message-ID: <CAORjz=NkFPvxfJqnLzvZpAno_5_do=_FSxoF+c=Z4UT87AUr9Q_at_mail.gmail.com>
On Mon, Oct 28, 2013 at 12:48 PM, Sanjay Mishra <smishra_97_at_yahoo.com>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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 28 2013 - 21:27:03 CET