Purpose
The V$SESSION_LONGOPS view displays the progress of index creation on the current OBServer node.
Note
This view is introduced since OceanBase Database V1.4.
Related tables/views
GV$SESSION_LONGOPS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SID | bigint(20) | NO | The 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 object on which the operation was performed. |
| SVR_IP | varchar(46) | NO | The IP address of the server on which the operation was performed. |
| SVR_PORT | bigint(20) | NO | The port number of the server on which the operation was performed. |
| START_TIME | date | NO | The start time. |
| ELAPSED_SECONDS | BIGINT(21) | NO | The amount of time elapsed since the start of the operation. |
| TIME_REMAINING | bigint(20) | NO | The estimated time remaining for the operation to complete. |
| LAST_UPDATE_TIME | date | NO | The time when the statistics were last updated. |
| MESSAGE | varchar(512) | NO | The additional information. |
