SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

find out query using specific DB link

602906Jun 12 2011 — edited Jun 13 2011

Hello,

Environment: 11G and Ksh script

Currently our Client is upgrading to new environment, so I need to find out which query in our Database use DB link to pull data from that client will be impacted.

for example,

select * from table_1@DB_link_1

All our SQL are embedded in UNIX script, so I use command line to search any scripts contain '@DB_link_1' but not find anything.

is it possible to search any dynamic view or any suggestion to search inside ORACLE database to see if any query using this 'DB_link_1'? I tried 'dba_db_links' but this does not show which query is using which DB link.

Thanks,

Thomas

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2011

Added on Jun 12 2011

4 comments

675 views