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.
A unique numeric identifier for a session
TRANSACTING, NOT_TRANSACTING, EXCEPTION_HANDLING, CONSTRUCTING, CONSTRUCTED, DECONSTRUCTING, or DECONSTRUCTED
The session identifier
The database user name under which the session opened
The total number of transactions executed within the session; this number provides a general indication of the level of activity in the session
The elapsed time in milliseconds of the mostly recently completed transaction
The total elapsed time in milliseconds in which transactions were being executed
The average elapsed time in milliseconds to complete a transaction
The total CPU time in milliseconds used to complete the most recent transaction
The total CPU time used to execute all transactions in this session; this total does not include transactions that are currently in progress
The average CPU time to complete a transaction; this average does not include transactions that are currently in progress
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