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 |