|
-
Sorry, Jeff, my previous suggestion was totaly out of place. GV$ and V$ views return the same values on non-OPS databases (where inst_id = USERENV('Instance'))! They are the same, as there is only one database instance per database. No wonder you recieved the same results from both V$DBLINK and GV$DBLINK.
I don't realy know of any way to find out which database links are used and by which session. Once a session establishes a connection to the remote database over DB_link, that link remains open for the duration of that session or until that session isues "ALTER SESSION CLOSE DATABASE LINK linkname;". So if you assume that db_links are not being closed explicitely, you can get information of *which sessions* have database link opened by querying V$SESSTAT where values of db_link related statistics (statistics# 185, 186 and 187 are related to db_link activity in 8.1.7) are > 0. But again, this will only tell which sessions have database link connections opened, not which database links are in use. I guess this is not what you want. It seems that you are only able to determine the opened db_links for your own session.
If you find of any way to answer your question, please post it here....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|