Note
This view is not supported. To view the created DBLink, 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 to the database link. |
| COMMIT_POINT_STRENGTH | NUMBER(38) | NO | The strength of the 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 the database link based on the OCI protocol. |
| OCI_CONN_CLOSED | NUMBER(38) | NO | The number of connections closed for the database link based on the OCI protocol. |
| OCI_STMT_QUERIED | NUMBER(38) | NO | The number of SQL queries executed for the database link based on the OCI protocol. |
| OCI_ENV_CHARSET | NUMBER(38) | NO | The character set type of the database link based on the OCI protocol. |
| OCI_ENV_NCHARSET | NUMBER(38) | NO | The national character set type of the database link based on the OCI protocol. |
| EXTRA_INFO | VARCHAR2(32767) | YES | Additional information. |