Is it possible to get a list of all currently opened database links?
Hi all,
I'm looking for a query showing me similar information like the view V$DBLINK, but for all current users in the database, i.e. I should be able to produce a report with at least sid and the name of the opened database link(s), because there are many different links.
In the net I found only a query that seems to give me the answer who is using at least one database link (but not which and/or how many):
I'm looking for a query showing me similar information like the view V$DBLINK, but for all current users in the database, i.e. I should be able to produce a report with at least sid and the name of the opened database link(s), because there are many different links.
In the net I found only a query that seems to give me the answer who is using at least one database link (but not which and/or how many):
select username,osuser,status,sid,serial#,machine,process,terminal,program
from v$session
where saddr in ( select k2gtdses from sys.x$k2gte );
0