Re: Testing database links

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_at_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_at_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_at_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_at_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_at_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).