Search notes:

Oracle: SYS.LINK$

select
   lnk.authpwd,
   lnk.authpwdx,
   lnk.authusr,
   lnk.ctime,
   lnk.flag,
   lnk.host,
   lnk.name,
   lnk.owner#,
   lnk.password,
   lnk.passwordx,
   lnk.userid
from
   SYS.link$ lnk;
As per a comment in $ORACLE_HOME/rdbms/admin/dbmsmetu.sql, spare1 and spare2 correspond to passwordx and authpwdx (and differ in that they're stored as BLOBs).

See also

select * from sys.link_logons$;
select * from sys.link_sources$;

Index