V$AW_LONGOPS

V$AW_LONGOPS displays status information about active SQL cursors initiated in an analytic workspace.

Column	Datatype	Description
`SESSION_ID`	`NUMBER`	Identifier for the session in which the fetch is executing. This table can be joined with `V$SESSION` to obtain the user name.
`CURSOR_NAME`	`VARCHAR2(64)`	Name assigned to the cursor
`COMMAND`	`VARCHAR2(17)`	Command that is actively fetching data from relational tables: `QUERY` `FETCH` `IMPORT` `EXECUTE` `UPDATE` `SOLVE` `CLEAR` `LOAD CUBE` `LOAD DIMENSION` `DIMENSION COMPILE`
`STATUS`	`VARCHAR2(9)`	Status of the current operation: `EXECUTING` - Command has begun executing `FETCHING` - Data is being fetched into the analytic workspace `FINISHED` - Command has finished executing. This status appears very briefly before the record disappears from the table.
`ROWS_PROCESSED`	`NUMBER`	Number of rows already inserted, updated, or deleted
`SEQ_NUMBER`	`NUMBER`	Sequence number in the Cube Build log
`SQL_ID`	`VARCHAR2(13)`	SQL ID of the statement
`TARGET`	`VARCHAR2(64)`	Operated object name
`TARGET_DESC`	`VARCHAR2(64)`	A brief description of the operated object
`START_TIME`	`DATE`	Time the command started executing
`LAST_UPDATE_TIME`	`DATE`	Last updated time
`ELAPSED_SECONDS`	`NUMBER`	Number of seconds between `START_TIME` and `LAST_UPDATE_TIME`
`SOFAR`	`NUMBER`	Number of units so far
`TOTALWORK`	`NUMBER`	Total number of units
`UNITS`	`VARCHAR2(6)`	Units description: `ROWS` `NODES` `VALUES`
`MESSAGE`	`VARCHAR2(512)`	Message for the user
`USERNAME`	`VARCHAR2(32)`	User name