Database Administration (MOSC)

MOSC Banner

Is it possible to get a list of all currently opened database links?

edited Jul 26, 2010 7:01AM in Database Administration (MOSC) 18 commentsAnswered
 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):
select username,osuser,status,sid,serial#,machine,process,terminal,program
from   v$session
where  saddr in ( select k2gtdses from sys.x$k2gte );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center