Note
This view is available starting with V4.0.0.
Purpose
This view displays the diagnostic information of compactions on the current node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| TYPE | VARCHAR2(64) | NO | The type of compaction. Valid values:
|
| LS_ID | NUMBER(38) | NO | The log stream ID. |
| TABLET_ID | NUMBER(38) | NO | The data tablet ID. |
| STATUS | VARCHAR2(15) | NO | The task status. |
| DIAGNOSE_INFO | VARCHAR2(1024) | NO | The diagnostic information. |
Sample query
Query the diagnostic information of compactions on the current node in the user tenant.
obclient [SYS]> SELECT * FROM SYS.V$OB_COMPACTION_DIAGNOSE_INFO;