Re: How to check number of Concurrent session from AWR
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 29 Oct 2013 09:43:46 -0700 (PDT)
Message-ID: <1383065026.36373.YahooMailNeo_at_web184804.mail.gq1.yahoo.com>
> What is
best way to check max number of concurrent session reported in
> a
specific AWR snapshot.
Hi, Sanjay,
Date: Tue, 29 Oct 2013 09:43:46 -0700 (PDT)
Message-ID: <1383065026.36373.YahooMailNeo_at_web184804.mail.gq1.yahoo.com>
> What is
best way to check max number of concurrent session reported in
> a
specific AWR snapshot.
Hi, Sanjay,
How about checking v$resource_limit for sessions' max_utilization? If the instance has been bounced, you can still find the number in dba_hist_resource_limit. Or similarly, v$license for sessions_highwater (plus number of background processes if you count them)? There's no dba_hist_* view for the latter.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 29 2013 - 17:43:46 CET