Note
This view is not supported. To view created DBLinks, use DBA_DB_LINKS, ALL_DB_LINKS, or USER_DB_LINKS.
Purpose
This view displays all database links ( IN_TRANSACTION=YES ) opened after a query session is started on all nodes. These database links must be committed or rolled back before they are closed.
Applicability
This view is available only in Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the remote database. |
| SVR_PORT | NUMBER(38) | NO | The port number of the remote database. |
| LINK_ID | NUMBER(38) | NO | The ID of the database link. |
| LOGGED_ON | NUMBER(38) | NO | Indicates whether the database link is logged on. |
| HETEROGENEOUS | NUMBER(38) | NO | Indicates whether the database accessed by the database link is heterogeneous. |
| PROTOCOL | NUMBER(38) | NO | The communication protocol of the database link: |
| OPEN_CURSORS | NUMBER(38) | NO | Indicates whether a cursor is opened for the database link. |
| IN_TRANSACTION | NUMBER(38) | NO | Indicates whether the database link is in a transaction. |
| UPDATE_SENT | NUMBER(38) | NO | Indicates whether an update is sent. |
| COMMIT_POINT_STRENGTH | NUMBER(38) | NO | The strength of the transaction commit point on the database link. |
| LINK_TENANT_ID | NUMBER(38) | NO | The tenant ID of the database link. |
| OCI_CONN_OPENED | NUMBER(38) | NO | The number of connections opened for links based on the OCI protocol. |
| OCI_CONN_CLOSED | NUMBER(38) | NO | The number of connections closed for links based on the OCI protocol. |
| OCI_STMT_QUERIED | NUMBER(38) | NO | The number of SQL statements queried for links based on the OCI protocol. |
| OCI_ENV_CHARSET | NUMBER(38) | NO | The character set type of links based on the OCI protocol. |
| OCI_ENV_NCHARSET | NUMBER(38) | NO | The national character set type of links based on the OCI protocol. |
| EXTRA_INFO | VARCHAR2(32767) | YES | Extra information. |