V$AW_LONGOPS

V$AW_LONGOPS provides status information about active SQL cursors initiated in the OLAP DML.

A cursor can be initiated within the OLAP DML using SQL FETCH, SQL IMPORT, or SQL EXECUTE, that is, SQL statements that can be declared and executed.

Column	Datatype	Description
`SESSION_ID`	`NUMBER`	The identifier for the session in which the fetch is executing. This table can be joined with V$SESSION to get the user name.
`CURSOR_NAME`	`VARCHAR2(64)`	The name assigned to the cursor in an OLAP DML `SQL DECLARE CURSOR` or `SQL PREPARE CURSOR` command.
`COMMAND`	`VARCHAR2(7)`	An OLAP DML command (`SQL IMPORT`, `SQL FETCH`, or `SQL EXECUTE`) that is actively fetching data from relational tables.
`STATUS`	`VARCHAR2(9)`	One of the following values: `EXECUTING`. The command has begun executing. `FETCHING`. Data is being fetched into the analytic workspace. `FINISHED`. The command has finished executing. This status appears very briefly before the record disappears from the table.
`ROWS_PROCESSED`	`NUMBER`	The number of rows already inserted, updated, or deleted.
`START_TIME`	`TIMESTAMP(3)`	The time the command started executing.