Re: How to check number of Concurrent session from AWR

From: Yong Huang <>
Date: Tue, 29 Oct 2013 09:43:46 -0700 (PDT)
Message-ID: <>

> 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

Received on Tue Oct 29 2013 - 17:43:46 CET

Original text of this message