How to trap any data selection through database link

[dasdeba]

Hi,

I am getting few errors for distributing lock. But actually there should not be any distributed transaction in my database. It may be a case that some one is accessing (selecting the data) the database through database links from other database. How can I trap those ? Though I have checked from v$sql for the sign "@", is there any good method for finding out this?

deba

[fraze]

An easy place to start could be your listener log - it will show you where any remote DB connections are coming from

[marist89]

I sample v$sesstat & v$sysstat for the dblink events.