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: Counting connections

Re: Counting connections

From: SUVAS LAKSHMIKUTTYAMMA <lsuvas_at_worldnet.att.net>
Date: 8 Aug 1998 23:13:41 GMT
Message-ID: <6qim35$d8h@bgtnsc02.worldnet.att.net>


You can use the v$session view to count the sessions and v$process to see the activity.
Please remember when using v$session to exclude the background processes
If you want to identify the client then make an entry like "USERNAME=<THE USER'S NAME>" in Oracle.ini file in each user's PC.

matcha wrote in message <35cc3a53.0_at_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
>
>
Received on Sat Aug 08 1998 - 18:13:41 CDT

Original text of this message

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