OLAP Dynamic Performance Views , 6 of 6

V$AW_SESSION_INFO

V$AW_SESSION_INFO provides information about each active session.

A transaction is a single exchange between a client session and Oracle OLAP. Multiple DML commands can execute within a single transaction, such as in a call to the DBMS_AW.EXECUTE procedure.

Column	Datatype	Description
`CLIENT_TYPE`	`VARCHAR2(64)`	OLAP
`SESSION_STATE`	`VARCHAR2(64)`	`TRANSACTING`, `NOT_TRANSACTING`, `EXCEPTION_HANDLING`, `CONSTRUCTING`, `CONSTRUCTED`, `DECONSTRUCTING`, or `DECONSTRUCTED`
`SESSION_HANDLE`	`NUMBER`	The session identifier
`USERID`	`VARCHAR2(64)`	The database user name under which the session opened
`CURR_DML_COMMAND`	`VARCHAR2(64)`	The DML command currently being executed
`PREV_DML_COMMAND`	`VARCHAR2(64)`	The DML command most recently completed.
`TOTAL_TRANSACTION`	`NUMBER`	The total number of transactions executed within the session; this number provides a general indication of the level of activity in the session
`TOTAL_TRANSACTION_TIME`	`NUMBER`	The total elapsed time in milliseconds in which transactions were being executed
`AVERAGE_TRANSACTION_TIME`	`NUMBER`	The average elapsed time in milliseconds to complete a transaction
`TRANSACTION_CPU_TIME`	`NUMBER`	The total CPU time in milliseconds used to complete the most recent transaction
`TOTAL_TRANSACTION_CPU_TIME`	`NUMBER`	The total CPU time used to execute all transactions in this session; this total does not include transactions that are currently in progress
`AVERAGE_TRANSACTION_CPU_TIME`	`NUMBER`	The average CPU time to complete a transaction; this average does not include transactions that are currently in progress