Home » RDBMS Server » Server Administration » Database link in use (Oracle 8I)
icon6.gif  Database link in use [message #318734] Wed, 07 May 2008 16:13 Go to next message
ora_w
Messages: 4
Registered: March 2007
Junior Member
Hello,

Please advice how to check if database link in use .

Thanks in advance.

Regards,
Ora
Re: Database link in use [message #318736 is a reply to message #318734] Wed, 07 May 2008 16:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
V$DBLINK
Re: Database link in use [message #318739 is a reply to message #318734] Wed, 07 May 2008 16:26 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Please advice how to check if database link in use .
Exactly what do you mean by "in use"?
Exists?
actively being used in some SQL at this moment in time?
or something else?
Re: Database link in use [message #318746 is a reply to message #318739] Wed, 07 May 2008 17:05 Go to previous messageGo to next message
ora_w
Messages: 4
Registered: March 2007
Junior Member
We have some database links , which are probably not in use any more by applications.

We would like to monitore them for ~ 4 months and drop if they not in use.

I would like to know, how to have confirmation ( for about ~100%), that they're not in use any more.

Thanks in advance.
Re: Database link in use [message #318749 is a reply to message #318734] Wed, 07 May 2008 17:23 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
1) remove the DBlinks & see what breaks
2) AUDIT the SQL that uses the DBLINKs
3) AUDIT the objects the DBLINKs reference
Re: Database link in use [message #318823 is a reply to message #318749] Thu, 08 May 2008 02:12 Go to previous messageGo to next message
ora_w
Messages: 4
Registered: March 2007
Junior Member
Thank you,

about the first option, we cannot drop then and see the impact.

Please advice how to audit db links ?
Re: Database link in use [message #318836 is a reply to message #318823] Thu, 08 May 2008 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't audit db link you:
Quote:
2) AUDIT the SQL that uses the DBLINKs
3) AUDIT the objects the DBLINKs reference

Regards
Michel
Re: Database link in use [message #318932 is a reply to message #318836] Thu, 08 May 2008 08:16 Go to previous messageGo to next message
ora_w
Messages: 4
Registered: March 2007
Junior Member
Hi,

Can you explain in more details how to do 2) and 3) ?

Regards,
Ora
Re: Database link in use [message #318952 is a reply to message #318734] Thu, 08 May 2008 08:57 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4007.htm#sthref5918
Previous Topic: Database Compression
Next Topic: During ADD Constraints
Goto Forum:
  


Current Time: Fri Dec 09 04:03:34 CST 2016

Total time taken to generate the page: 0.05021 seconds