Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
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

DBA_HIST_ACTIVE_SESS_HISTORY

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 SESSION_STATE = ON CPU, then this column will be NULL.

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:
  • WAITING

  • ON CPU

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:
  • VALID

  • NO HOLDER

  • GLOBAL

  • NOT IN WAIT

  • UNKNOWN

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