Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-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
Feedback

Go to previous page Go to next page
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 DML commands can execute within a single transaction, such as in a call to the DBMS_AW.EXECUTE procedure.

Column Datatype Description

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

CURR_DML_COMMAND

VARCHAR2(64)

The DML command currently being executed

PREV_DML_COMMAND

VARCHAR2(64)

The DML command most recently completed.

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

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