DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session history of recent system activity. This view contains snapshots of V$ACTIVE_SESSION_HISTORY. See "V$ACTIVE_SESSION_HISTORY" for further interpretation details for many of these columns (except SNAP_ID, DBID, and INSTANCE_NUMBER).
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
Unique snapshot ID | |
DBID |
NUMBER |
Database ID for the snapshot | |
INSTANCE_NUMBER |
NUMBER |
Instance number for the snapshot | |
SAMPLE_ID |
NUMBER |
ID of the sample | |
SAMPLE_TIME |
TIMESTAMP(3) |
Time of the sample | |
SESSION_ID |
NUMBER |
Session identifier | |
SESSION_SERIAL# |
NUMBER |
Session serial number (used to uniquely identify a session's objects) | |
SESSION_TYPE |
VARCHAR2(10) |
Session type, either FOREGROUND or BACKGROUND |
|
USER_ID |
NUMBER |
Oracle user identifier | |
SQL_ID |
VARCHAR2(13) |
SQL identifier of the SQL statement that is currently being executed | |
SQL_CHILD_NUMBER |
NUMBER |
Child number of the SQL statement that is currently being executed | |
SQL_OPCODE |
NUMBER |
Indicates what phase of operation the SQL statement is in | |
FORCE_MATCHING_SIGNATURE |
NUMBER |
The signature used when the CURSOR_SHARING parameter is set to FORCE |
|
TOP_SQL_ID |
VARCHAR2(13) |
??? | |
TOP_SQL_OPCODE |
NUMBER |
??? | |
SQL_PLAN_HASH_VALUE |
NUMBER |
Numerical representation of the SQL plan for the cursor | |
SQL_PLAN_LINE_ID |
NUMBER |
??? | |
SQL_PLAN_OPERATION |
VARCHAR2(64) |
??? | |
SQL_PLAN_OPTIONS |
VARCHAR2(64) |
??? | |
SQL_EXEC_ID |
NUMBER |
??? | |
SQL_EXEC_START |
DATE |
??? | |
PLSQL_ENTRY_OBJECT_ID |
NUMBER |
Object ID of top-most PL/SQL subprogram on the stack (or NULL if there is no PL/SQL subprogram on the stack). | |
PLSQL_ENTRY_SUBPROGRAM_ID |
NUMBER |
Subprogram ID of the top-most PL/SQL subprogram on the stack (or NULL if there is no PL/SQL subprogram on the stack). | |
PLSQL_OBJECT_ID |
NUMBER |
Object ID of the currently executing PL/SQL subprogram (or NULL if executing SQL) | |
PLSQL_SUBPROGRAM_ID |
NUMBER |
Subprogram ID of the currently executing PL/SQL object (or NULL if executing SQL) | |
QC_INSTANCE_ID |
NUMBER |
Query coordinator instance ID | |
QC_SESSION_ID |
NUMBER |
Query coordinator session ID | |
QC_SESSION_SERIAL# |
NUMBER |
??? | |
EVENT |
VARCHAR2(64) |
If SESSION_STATE = WAITING, then the event for which the session was waiting at the time of sampling.
If |
|
EVENT_ID |
NUMBER |
Identifier of the resource or event for which the session is waiting or for which the session last waited | |
SEQ# |
NUMBER |
Sequence number that uniquely identifies the wait (incremented for each wait) | |
P1TEXT |
VARCHAR2(64) |
Text of first additional parameter | |
P1 |
NUMBER |
First additional parameter | |
P2TEXT |
VARCHAR2(64) |
Text of second additional parameter | |
P2 |
NUMBER |
Second additional parameter | |
P3TEXT |
VARCHAR2(64) |
Text of third additional parameter | |
P3 |
NUMBER |
Third additional parameter | |
WAIT_CLASS |
VARCHAR2(64) |
Wait class name of the event for which the session was waiting at the time of sampling. Interpretation is similar to that of the EVENT column. Maps to V$SESSION.WAIT_CLASS. |
|
WAIT_CLASS_ID |
NUMBER |
Wait class identifier of the event for which the session was waiting at the time of sampling. Interpretation is similar to that of the EVENT column. Maps to V$SESSION.WAIT_CLASS_ID. |
|
WAIT_TIME |
NUMBER |
Total wait time for the event for which the session last waited (0 if currently waiting) |
|
SESSION_STATE |
VARCHAR2(7) |
Session state:
|
|
TIME_WAITED |
NUMBER |
Time that the current session actually spent waiting for the event. This column is set for waits that were in progress at the time the sample was taken. | |
BLOCKING_SESSION_STATUS |
VARCHAR2(11) |
Status of the blocking session:
|
|
BLOCKING_SESSION |
NUMBER |
Session identifier of the blocking session. Populated only when the session was waiting for enqueues or a "buffer busy" wait. Maps to V$SESSION.BLOCKING_SESSION. |
|
BLOCKING_SESSION_SERIAL# |
NUMBER |
Serial number of the blocking session | |
CURRENT_OBJ# |
NUMBER |
Object ID of the object that the session is currently referencing. This information is only available if the session was waiting for Application, Cluster, Concurrency, and User I/O wait events. Maps to V$SESSION.ROW_WAIT_OBJ#. |
|
CURRENT_FILE# |
NUMBER |
File number of the file containing the block that the session is currently referencing. This information is only available if the session was waiting for Cluster, Concurrency, and User I/O wait events. Maps to V$SESSION.ROW_WAIT_FILE#. |
|
CURRENT_BLOCK# |
NUMBER |
ID of the block that the session is currently referencing | |
CURRENT_ROW# |
NUMBER |
??? | |
CONSUMER_GROUP_ID |
NUMBER |
??? | |
XID |
RAW(8) |
Transaction ID that the session was working on at the time of sampling. V$SESSION does not contain this information. |
|
REMOTE_INSTANCE# |
NUMBER |
Remote instance identifier that will serve the block that this session is waiting for. This information is only available if the session was waiting for cluster events. | |
IN_CONNECTION_MGMT |
VARCHAR2(1) |
Indicates whether the session was doing connection management at the time of sampling (Y) or not (N) |
|
IN_PARSE |
VARCHAR2(1) |
Indicates whether the session was parsing at the time of sampling (Y) or not (N) |
|
IN_HARD_PARSE |
VARCHAR2(1) |
Indicates whether the session was hard parsing at the time of sampling (Y) or not (N) |
|
IN_SQL_EXECUTION |
VARCHAR2(1) |
Indicates whether the session was executing SQL statements at the time of sampling (Y) or not (N) |
|
IN_PLSQL_EXECUTION |
VARCHAR2(1) |
Indicates whether the session was executing PL/SQL at the time of sampling (Y) or not (N) |
|
IN_PLSQL_RPC |
VARCHAR2(1) |
Indicates whether the session was executing inbound PL/SQL RPC calls at the time of sampling (Y) or not (N) |
|
IN_PLSQL_COMPILATION |
VARCHAR2(1) |
Indicates whether the session was compiling PL/SQL at the time of sampling (Y) or not (N) |
|
IN_JAVA_EXECUTION |
VARCHAR2(1) |
Indicates whether the session was executing Java at the time of sampling (Y) or not (N) |
|
IN_BIND |
VARCHAR2(1) |
Indicates whether the session was doing bind operations at the time of sampling (Y) or not (N) |
|
IN_CURSOR_CLOSE |
VARCHAR2(1) |
Indicates whether the session was closing a cursor at the time of sampling (Y) or not (N) |
|
SERVICE_HASH |
NUMBER |
Hash that identifies the Service | |
PROGRAM |
VARCHAR2(48) |
Name of the operating system program | |
MODULE |
VARCHAR2(48) |
Name of the currently executing module as set by the DBMS_APPLICATION_INFO.SET_MODULE procedure |
|
ACTION |
VARCHAR2(32) |
Name of the currently executing action as set by the DBMS_APPLICATION_INFO.SET_ACTION procedure |
|
CLIENT_ID |
VARCHAR2(64) |
Client identifier of the session |