Connection to the gateway

A connection to the gateway is established through a database link when it is first used in an Oracle session. In this context, a connection refers to the connection between the Oracle database and the gateway. The connection remains established until the Oracle session ends. Another session or user can access the same database link and get a distinct connection to the gateway and ODBC data source. If you want to close a database link during a session, you can do so with the ALTER SESSION statement.

If you want to check for existing database links you can use this query:

select * from all_db_links;