RE: How to check number of Concurrent session from AWR
From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Mon, 28 Oct 2013 15:30:10 -0700
Message-ID: <FD1D618E4F164D4C8BA5513D4268174A01A1AA913543_at_EXCHCLUSTER1-02.win.slac.stanford.edu>
Have you defined a value for dramatically higher? have you defined a time for how long the condition needs to exist? Dramatically session counts are often due to misbehaving connection pools or application servers.
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra [smishra_97_at_yahoo.com] Sent: Monday, October 28, 2013 12:48 PM
To: oracle-l_at_freelists.org
Subject: How to check number of Concurrent session from AWR
Date: Mon, 28 Oct 2013 15:30:10 -0700
Message-ID: <FD1D618E4F164D4C8BA5513D4268174A01A1AA913543_at_EXCHCLUSTER1-02.win.slac.stanford.edu>
Have you defined a value for dramatically higher? have you defined a time for how long the condition needs to exist? Dramatically session counts are often due to misbehaving connection pools or application servers.
Ian A. MacGregor
SLAC National Accelerator Laboratory
Computing Division
To offer the best IT service at the lab and be the IT provider of choice.
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra [smishra_97_at_yahoo.com] Sent: Monday, October 28, 2013 12:48 PM
To: oracle-l_at_freelists.org
Subject: How to check number of Concurrent session from AWR
Hi
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
Sanjay
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 28 2013 - 23:30:10 CET