Re: How to check number of Concurrent session from AWR

From: Jared Still <>
Date: Mon, 28 Oct 2013 13:27:03 -0700
Message-ID: <>

On Mon, Oct 28, 2013 at 12:48 PM, Sanjay Mishra <>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: Home Page:

Received on Mon Oct 28 2013 - 21:27:03 CET

Original text of this message