Number of database connections

From: Tom Bebee <bebeet_at_mail.welchallyn.com>
Date: Wed, 28 Apr 1999 14:22:20 GMT
Message-ID: <7g75im$52f$1@nnrp1.dejanews.com>

I need to monitor the number of concurrent connections we have to several of our databases. We will be upgrading the database and also switching from run-time licensing to actual user licensing. The individual who bought the run-time licenses over estimated the number of users we have accessing each SID and I would like to have a valid number of concurrent users to base our new purchasing on. It looks like I can access V$SESSION, but is it enough just to run a query periodically looking for STATUS=ACTIVE as a measure of true usage?

Any information would be appreciated.

TIA.
--

Tom Bebee
Welch Allyn Inc.
Skaneateles, Falls NY

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 09:22:20 CDT