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 withV$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
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data