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 ID of the tenant. |
| 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 the database link has open cursors. |
| IN_TRANSACTION | NUMBER(38) | NO | Indicates whether the database link is in a transaction. |
| UPDATE_SENT | NUMBER(38) | NO | Indicates whether the database link has updates. |
| COMMIT_POINT_STRENGTH | NUMBER(38) | NO | The strength of the transaction commit point on the database link. |
| LINK_TENANT_ID | NUMBER(38) | NO | The ID of the tenant that created the database link. |
| OCI_CONN_OPENED | NUMBER(38) | NO | The number of connections opened on links based on the OCI protocol. |
| OCI_CONN_CLOSED | NUMBER(38) | NO | The number of connections closed on links based on the OCI protocol. |
| OCI_STMT_QUERIED | NUMBER(38) | NO | The number of SQL queries executed on 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. |