VIEW: SYS.ALL_DB_LINKS

Source

View Text - Preformatted

select u.name, l.name, l.userid, l.host, l.ctime
from sys.link$ l, sys.user$ u
where l.owner# in ( select kzsrorol from x$kzsro )
  and l.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME
, L.NAME
, L.USERID
, L.HOST
, L.CTIME FROM SYS.LINK$ L
, SYS.USER$ U WHERE L.OWNER# IN ( SELECT KZSROROL
FROM X$KZSRO )
AND L.OWNER# = U.USER#