Purpose
v$session_longops displays the progress of index creation on the current OBServer node.
Related tables/views
gv$session_longops
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SID | bigint(20) | NO | The session ID. |
| OPNAME | varchar(128) | NO | The name of the operation. |
| TARGET | varchar(128) | NO | The object on which the operation was performed. |
| SVR_IP | varchar(32) | NO | The IP address of the OBServer node on which the operation was performed. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node on which the operation was performed. |
| START_TIME | bigint(20) | NO | The start time. |
| ELAPSED_SECONDS | DECIMAL(24,4) | 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 | bigint(20) | NO | The time when the statistics were last updated. |
| MESSAGE | varchar(500) | NO | The additional information. |