Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent, Client connection monitoring
v$session and v$process contain information about the client connections. You could query these tables to determine which clients had multiple connections.
You could also use profiles to limit the number of session allowed for each user. Maybe this could stop your problem before it starts?
_vivek_at_yahoo.com wrote:
>
> Hi all,
>
> I need information on how, what and where is information stored about a remote
> client connection. I want to be able to monitor the state of the connection as
> in whether it is alive, inactive or hung.
> I would like to be able to identify and disconnect a particular session if
> multiple ones with the same userID are running.
>
> This is an urgent request for help.
>
> Thanks in advance,
>
> Vivek
> _vivek_at_yahoo.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Feb 27 1998 - 00:00:00 CST