Message-ID: <F001.005545BA.20030221073353@fatcity.com>
Date: Fri, 21 Feb 2003 07:33:53 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Arup Nanda" <orarup@hotmail.com>
Subject: Re: Testing database links
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Charu,

The view V$DBLINK can show you if the link is in use.

select open_cursors, in_transaction
from v$dblonk
where db_link = 'mylink'

HTH.

Arup Nanda

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Friday, February 21, 2003 8:03 AM


> Dear Listers,
>
> Oracle 8i HP-UX11.
>
> We have a database link with a remote database which is accessed from the
> application code. In the application code, a call is made to the
> 'dbms_session.close_database_link' procedure (that is what they claim!!).
>
> We want to track the call to the database link and the subsequent closure.
> We don't have any access to the remote system to check the remote session
> being created and closed.
>
> Is there any way (dynamic performance view etc.) which would show the
> database link being in use and closed again on the local database itself?
>
> Thanks & regards,
> Charu
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Charu Joshi
>   INET: joshic@mahindrabt.com
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup@hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).