Skip to Main Content

Oracle Database Discussions

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!

How to determine when a db_link was last used

561649May 9 2007 — edited May 10 2007
So we have over 1,000 db_links and want to clean up the old ones that are never used, but we are not sure which are being used and which are not.

Is there any way to check Oracle to see when the last time or last day that a db_link was used? If there is not a way to check the database for this information, is there anyway to create a trigger or pl/sql code or anything that could track or log when the db_link is used?
(Perhaps there is some info deep inside the data dictionary that keeps track of this in real time, so that I could see which db_links have recently been used in the last 30 minutes or something.)

Any insight on this would be great thanks!!!

Ryan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2007
Added on May 9 2007
4 comments
2,500 views