Toad World® Forums

How can I know who is using DB Links?


#1

I have many base, users and links. I need to know that who is using db links?


#2

There are statistics that tell you how many bytes etc have gone our or come in over a link. There is nothing I know of that mentions who did it though.

I suspect you might end up data mining the listener log files at the far end, looking for connections from the near end database server. But there’s not much you’ll get out of it.

Cheers,

Norm [ TeamT ]

On 17 June 2015 08:26:24 BST, “iz.tamira” bounce-iztamira@toadworld.com wrote:

How can I know who is using DB Links?

Thread created by iz.tamira
I have many base, users and links. I need to know that who is using db links?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Oracle notifications altogether.

Toad World - Oracle Discussion Forum

Flag this post as spam/abuse.

Sent from my Android device with K-9 Mail. Please excuse my brevity.


#3

you can create user(s) having name of dblink(s) and create dblink(s) based on thah(them).

then in destination db(s) you can check .

i have used so and was ok for me!


#4

Unfortunately, Oracle doesn’t maintain any statistics against DB Link utilization. However, you may try looking for the SQL queries which are using those DB Links and in turn find the users who are actually running those SQL queries.

Hope this helps !

Cheers,

Abbas