Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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
Report message to a moderator
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: 1883
Registered: April 2006
Senior Member
V$DBLINK
Report message to a moderator
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
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in 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?
Report message to a moderator
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.
Report message to a moderator
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
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in 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
Report message to a moderator
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 ?
Report message to a moderator
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: 15238
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
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
Report message to a moderator
Re: Database link in use [message #318952 is a reply to message #318734 ] Thu, 08 May 2008 08:57 Go to previous message
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4007.htm#sthref5918
Report message to a moderator
Previous Topic:Database Compression
Next Topic:During ADD Constraints
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 00:44:13 CDT 2008

Total time taken to generate the page: 0.15084 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.