Re: Q: Determining max concurrent users

From: Ari Kaplan <akaplan_at_interaccess.com>
Date: 1997/12/18
Message-ID: <67bkfj$4k7$1@nntp3.interaccess.com>#1/1

Anastasio (alexi_anastasio_at_usa.net) wrote:
: We are using Oracle 7 on Unix and would like to see what the highest
: number of concurrent users has been. On an earlier version (PC platform)
: there was an entry in one of the log files that included a "High water
: mark" that would tell you that number. The only reference I can find to
: that "mark" now is for dataloading.
: Any suggestions?
: Thank you,
: alexi_anastasio_at_usa.net

The following script will show the current logons, cumulative logons (the number of users that connected since the database started), and highwater mark (highest number of simultaneous users since the database started):

SELECT rpad(c.name||':',11)||

       rpad(' current logons='||(to_number(b.sessions_current)-1),20)||
       'cumulative logons='||rpad(substr(a.value,1,10),10)||
       'highwater mark='||b.sessions_highwater Information

FROM v\$sysstat a, v\$license b, v\$database c WHERE a.name = 'logons cumulative'

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 132+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Received on Thu Dec 18 1997 - 00:00:00 CST