Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays the execution status and progress of DDL operations in the cluster.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SID | bigint(20) | NO | Session ID |
| TRACE_ID | varchar(64) | NO | The trace ID of the statement. |
| OPNAME | varchar(64) | NO | The name of the operation. |
| TARGET | varchar(64) | NO | The target of the operation. |
| SVR_IP | varchar(46) | NO | The IP address of the server where the operation is performed. |
| SVR_PORT | bigint(20) | NO | The port number of the server where the operation is performed. |
| START_TIME | date | NO | The start time of the operation. |
| ELAPSED_SECONDS | bigint(21) | NO | The time consumed. |
| TIME_REMAINING | bigint(20) | NO | The estimated remaining time. |
| LAST_UPDATE_TIME | date | NO | The time when the statistics were last updated. |
| MESSAGE | varchar(512) | NO | Remarks. |