Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays the execution status and progress of DDL operations on the current OBServer node.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SID | bigint(20) | NO | Session ID |
| TRACE_ID | varchar(64) | NO | Trace ID of the statement |
| OPNAME | varchar(64) | NO | Operation name |
| TARGET | varchar(64) | NO | Operation object |
| SVR_IP | varchar(46) | NO | IP address of the server where the operation is performed |
| SVR_PORT | bigint(20) | NO | Port number of the server where the operation is performed |
| START_TIME | date | NO | Start time |
| ELAPSED_SECONDS | bigint(21) | NO | Time consumed |
| TIME_REMAINING | bigint(20) | NO | Estimated remaining time |
| LAST_UPDATE_TIME | date | NO | Time when the statistics were last updated |
| MESSAGE | varchar(512) | NO | Remarks |