Xref: alice comp.databases.oracle.server:26528
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!sunqbc.risq.qc.ca!news.uunet.ca!news1.ottawa.cyberus.ca!news.cyberus.ca!not-for-mail
From: rpdata@cyberus.ca (RP DATA SOLUTIONS)
Newsgroups: comp.databases.oracle.server
Subject: Re: Counting connections
Date: Sat, 08 Aug 1998 19:51:37 GMT
Organization: Cyberus Online Inc.
Lines: 31
Message-ID: <35ccac47.100538106@news.cyberus.ca>
References: <35cc3a53.0@nemo.idirect.com> <6qhev0$2t3$1@oak.prod.itd.earthlink.net>
X-Trace: news1.ottawa.cyberus.ca 902590865 28860 209.195.65.139 (8 Aug 1998 15:41:05 GMT)
X-Complaints-To: support@cyberus.ca
NNTP-Posting-Date: 8 Aug 1998 15:41:05 GMT
X-Newsreader: Forte Free Agent 1.11/32.235

A good one is the v$license which tells you number of current
connections and also the highgest number of concurrent users since the
instance was last brought up... Or the v$session which tells you who's
currently connected...

Cheers,
Robert Prendin
"Remington" <remxub@earthlink.net> wrote:

>Should I somewhere in the data dictionary (dba_*,or v$*)
>matcha wrote in message <35cc3a53.0@nemo.idirect.com>...
>>Hi,
>>How can I count number of connections and activities in a Client/Server
>>environment where clients connect to the database server when
>>retrieve/update data?
>>
>>Thanks for help
>>
>>Cemal
>>
>>
>
>

#****************************************************
#	RP Data Solutions Inc.
#	Specializing in ORACLE DBA Support Services
#       We offer 24HR remote DBA support!!!
#****************************************************