7.78 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 |
|---|---|---|
|
|
|
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:
|