Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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