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-compatible 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. |