DB links
SELECT L.DB_LINK, L.USERNAME, L.HOST, L.CREATED, L.OWNER, TO_NUMBER(BITAND(K.FLAG, 1)) SHARED, K.AUTHUSR
FROM SYS.DBA_DB_LINKS L, SYS.KU$_DBLINK_VIEW K
WHERE L.OWNER = K.OWNER_NAME (+)
AND L.DB_LINK = K.NAME (+)
AND L.OWNER IN (:OWN, 'PUBLIC')