:
[EMAIL PROTECTED] Subject: Re: Determine max # of
concurrent users at schema level
3 8:43
PM
Subject: Re: Determine max # of concurrent users at
schema level
[EMAIL PROTECTED] desc
v$license
Name
Null? Type ---
SESSIONS_MAX
NUMBER
SESSIONS_WARNING
NUMBER
SESSIONS_CURRENT
NUMBER
SESSIONS_HIGHWATER
NUMBER
USERS_M
Hi All,
V$LICENSE will show max # of concurrent users since instance startup. Is
there another view or something to determine max # of concurrent sessions
for
each schema?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat
[EMAIL PROTECTED] wrote:
Hi All,
V$LICENSE will show max # of concurrent users since instance startup. Is
there another view or something to determine max # of concurrent sessions
for
each schema?
Thanks
Rick
AUDIT on connections, and good ol' SQL ...
--
Regards,
Stephane
Rick,
There is no such view, but can be very simply obtained by turning on
auditing and placing auditing for connects for user. Later you can aanalyze
the connects and disconnects in a given time period to get max concurrent
access.
HTH.
Arup Nanda
- Original Message -
To: Multiple
:
Sent by: Subject: Re: Determine max # of
concurrent users at schema level
[EMAIL PROTECTED
Faroult To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
sfaroult@orio cc:
le.com Subject: Re: Determine max # of
concurrent users
