7.85 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 commands can execute within a single transaction.

Column Datatype Description

SESSION_ID

NUMBER

A unique numeric identifier for a session

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

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

TRANSACTION_TIME

NUMBER

The elapsed time in milliseconds of the mostly recently completed transaction

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

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