Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I monitor the number of Oracle connections. SQL*Net + multiple hosts.

Re: How do I monitor the number of Oracle connections. SQL*Net + multiple hosts.

From: Alexey E. Neckrasow <nec_at_leaves.spb.su>
Date: 1996/11/05
Message-ID: <327F3FB4.6E47@leaves.spb.su>#1/1

Hi, George!

Try this query:
select count (*)
from v$session
where username is not null;

It will give you the number of concurrent user sessions.

George Dau wrote:
>
> G'day,
>
> We have 25 Instances spread over 7 machines - one NT 3.51 Server and 7 Sun
> Solaris. Three of the instances use Mincom's TP system to connect multiple end
> users to one Oracle connection.
>
> Some people connect through SQL*NET V1 and V2. Most connect through Forms based
> terminal sessions.
>
> People will also be connecting with ODBC and related tools.
>
> We have a network license agreement, so we only need the total connections over
> all the machines.
>
> Anyone have any ideas on how to count the number of connections being used?
>
> Can I get at the value in "License High Water Mark" on the fly - not just at
> shutdown? Is this really the max number of concurrent connections since the db
> was started?
>
> The follow seemed as though they might be useful, but always seem to be zero:
> LICENSE_MAX_SESSION = 0
> LICENSE_SESSIONS_WARNING = 0
> LICENSE_MAX_USERS = 0
>
> Thanks for any ideas on this.
>
> George Dau
> gedau_at_mim.com.au
 

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.
Received on Tue Nov 05 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US