Re: How to close an open database link ?

From: Fraser McCallum <fmcc_at_NOSPAMiname.com>
Date: Thu, 24 May 2001 00:39:32 +0100
Message-ID: <3b0c4c3c$1@mk-nntp-1.news.uk.worldonline.com>

Gerald

You will have to do this at the operating system level as there is no view in the database that gives you this. A netstat -p piped to a suitable grep would do this on a UNIX machine.
Kill the user session on the destination database.

Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"Petra Hein/Gerald Bauer" <Petra.Hein-Gerald.Bauer_at_t-online.de> wrote in message news:9eh9mt$pqv$06$1_at_news.t-online.com...
> Hi,
>
> I've two questions concerning database links:
>
> 1. How can I determine all open database links of all sessions in the
> database ?
> 2. Is there a statement which can be used for closing an open database
link
> of a specific session (i.e. not my own session, but an open database link
in
> another user's session) ?
>
> Thanks,
> Gerald
>
>
Received on Wed May 23 2001 - 18:39:32 CDT