V$SESSION_LONGOPS
V$SESSION_LONGOPS displays the progress of ongoing operations.
| Name | Type | Description |
|---|---|---|
| sid | Bigint | OID of the running background process |
| serial# | Integer | Sequence number of the running background process, which is 0 in DWS. |
| sofar | Integer | Completed workload, which is empty in DWS. |
| totalwork | Integer | Total workload, which is empty in DWS. |