OraFAQ Forum: Server Administration » Database link in use

Home » RDBMS Server » Server Administration » Database link in use (Oracle 8I)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database link in use [message #318734]

Wed, 07 May 2008 16:13

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

ebrian
Messages: 2794
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

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: Database link in use [message #318746 is a reply to message #318739]

Wed, 07 May 2008 17:05

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