-
How to trap any data selection through database link
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
-
An easy place to start could be your listener log - it will show you where any remote DB connections are coming from
-
I sample v$sesstat & v$sysstat for the dblink events.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|