Search notes:

Oracle: DBA_DB_LINK_SOURCES

dba_db_link_sources lists open database links that are opened to the local database.

select
   dls.source_id,
   dls.username,          -- Name of user who logged into the local database (corresponds to `username` in `v$session`)
   dls.db_name,
   dls.first_logon_time,
   dls.last_logon_time,
   dls.logon_count,
   dls.dbid,
   dls.db_unique_name,
   dls.host_name,
   dls.ip_address,
   dls.protocol,        -- ipc, sdp, tcp, tcps or NULL.
   dls.user#
from
   dba_db_link_sources dls;

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759562213, '216.73.216.149', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/db/link_sources(56): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51

Oracle: DBA_DB_LINK_SOURCES

See also