• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. V$SESSION_LONGOPS

V$SESSION_LONGOPS

V$SESSION_LONGOPS displays the progress of ongoing operations.

Table 1 V$SESSION_LONGOPS columns

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.