No question at this time
DBA Top 10
1 M. Cadot 5800
2 B. Vroman 3800
3 J. Péran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 800
6 D. Johnson 700
7 T. Boles 600
8 D. Walgude 400
9 J. Alcroft 200
9 S. Spb 200
9 P. Wisse 200
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48667
Total active users1334
Act. users last 24h0
Act. users last hour0
Registered user hits last week21
Registered user hits last month191
Go up

how to find which remote db is accessing source db over db link
Next thread: rollback taking long time oracle
Prev thread: active dataguard usage

Message Score Author Date
In my production db some key tables are getting ac...... sandesh deshmukh Sep 02, 2021, 10:44

Follow up by mail Click here

Subject: how to find which remote db is accessing source db over db link
Author: sandesh deshmukh, India
Date: Sep 02, 2021, 10:44, 263 days ago
Os info: Windows
Oracle info: 11g
Message: In my production db some key tables are getting accessed by remote connection over dblink,I need to identify from where these queries are coming from.

nothing is there in V$sesson table for sqlid,but able to find sql in v$sql dictionary,Kindly advice
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here