Re: Number of database connections

Tom,

You can query the V$SESSION periodically, although with just a query that looks for an active status you're going to get all of the Oracle processes included in your count.

Alternatively, you could consider auditing connections to the database, which
includes logon and logoff timestamps.

HTH Graham.

--
Empowerment - delegating the responsibility but not the authority.

Opinions expressed do not necessarily reflect those of Abbott Laboratories.

Tom Bebee wrote in message <7g75im$52f$1_at_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 - 15:07:44 CDT