DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_HIST_ACTIVE_SESS_HISTORY

Object Details
Object Name: DBA_HIST_ACTIVE_SESS_HISTORY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Active Session Historical Statistics Information

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAP_ID NUMBER
Yes
DBID NUMBER
Yes
INSTANCE_NUMBER NUMBER
Yes
SAMPLE_ID NUMBER
Yes
SAMPLE_TIME TIMESTAMP(3) (11) Yes
SESSION_ID NUMBER
Yes
SESSION_SERIAL# NUMBER

SESSION_TYPE VARCHAR2 (10)
FLAGS NUMBER

USER_ID NUMBER

SQL_ID VARCHAR2 (13)
IS_SQLID_CURRENT VARCHAR2 (1)
SQL_CHILD_NUMBER NUMBER

SQL_OPCODE NUMBER

SQL_OPNAME VARCHAR2 (64)
FORCE_MATCHING_SIGNATURE NUMBER

TOP_LEVEL_SQL_ID VARCHAR2 (13)
TOP_LEVEL_SQL_OPCODE NUMBER

SQL_PLAN_HASH_VALUE NUMBER

SQL_FULL_PLAN_HASH_VALUE NUMBER

SQL_ADAPTIVE_PLAN_RESOLVED NUMBER

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

PLSQL_ENTRY_SUBPROGRAM_ID NUMBER

PLSQL_OBJECT_ID NUMBER

PLSQL_SUBPROGRAM_ID NUMBER

QC_INSTANCE_ID NUMBER

QC_SESSION_ID NUMBER

QC_SESSION_SERIAL# NUMBER

PX_FLAGS NUMBER

EVENT VARCHAR2 (64)
EVENT_ID NUMBER

SEQ# NUMBER

P1TEXT VARCHAR2 (64)
P1 NUMBER

P2TEXT VARCHAR2 (64)
P2 NUMBER

P3TEXT VARCHAR2 (64)
P3 NUMBER

WAIT_CLASS VARCHAR2 (64)
WAIT_CLASS_ID NUMBER

WAIT_TIME NUMBER

SESSION_STATE VARCHAR2 (7)
TIME_WAITED NUMBER

BLOCKING_SESSION_STATUS VARCHAR2 (11)
BLOCKING_SESSION NUMBER

BLOCKING_SESSION_SERIAL# NUMBER

BLOCKING_INST_ID NUMBER

BLOCKING_HANGCHAIN_INFO VARCHAR2 (1)
CURRENT_OBJ# NUMBER

CURRENT_FILE# NUMBER

CURRENT_BLOCK# NUMBER

CURRENT_ROW# NUMBER

TOP_LEVEL_CALL# NUMBER

TOP_LEVEL_CALL_NAME VARCHAR2 (64)
CONSUMER_GROUP_ID NUMBER

XID RAW (8)
REMOTE_INSTANCE# NUMBER

TIME_MODEL NUMBER

IN_CONNECTION_MGMT VARCHAR2 (1)
IN_PARSE VARCHAR2 (1)
IN_HARD_PARSE VARCHAR2 (1)
IN_SQL_EXECUTION VARCHAR2 (1)
IN_PLSQL_EXECUTION VARCHAR2 (1)
IN_PLSQL_RPC VARCHAR2 (1)
IN_PLSQL_COMPILATION VARCHAR2 (1)
IN_JAVA_EXECUTION VARCHAR2 (1)
IN_BIND VARCHAR2 (1)
IN_CURSOR_CLOSE VARCHAR2 (1)
IN_SEQUENCE_LOAD VARCHAR2 (1)
IN_INMEMORY_QUERY VARCHAR2 (1)
IN_INMEMORY_POPULATE VARCHAR2 (1)
IN_INMEMORY_PREPOPULATE VARCHAR2 (1)
IN_INMEMORY_REPOPULATE VARCHAR2 (1)
IN_INMEMORY_TREPOPULATE VARCHAR2 (1)
CAPTURE_OVERHEAD VARCHAR2 (1)
REPLAY_OVERHEAD VARCHAR2 (1)
IS_CAPTURED VARCHAR2 (1)
IS_REPLAYED VARCHAR2 (1)
SERVICE_HASH NUMBER

PROGRAM VARCHAR2 (64)
MODULE VARCHAR2 (64)
ACTION VARCHAR2 (64)
CLIENT_ID VARCHAR2 (64)
MACHINE VARCHAR2 (64)
PORT NUMBER

ECID VARCHAR2 (64)
DBREPLAY_FILE_ID NUMBER

DBREPLAY_CALL_COUNTER NUMBER

TM_DELTA_TIME NUMBER

TM_DELTA_CPU_TIME NUMBER

TM_DELTA_DB_TIME NUMBER

DELTA_TIME NUMBER

DELTA_READ_IO_REQUESTS NUMBER

DELTA_WRITE_IO_REQUESTS NUMBER

DELTA_READ_IO_BYTES NUMBER

DELTA_WRITE_IO_BYTES NUMBER

DELTA_INTERCONNECT_IO_BYTES NUMBER

PGA_ALLOCATED NUMBER

TEMP_SPACE_ALLOCATED NUMBER

DBOP_NAME VARCHAR2 (64)
DBOP_EXEC_ID NUMBER

CON_DBID NUMBER

CON_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      SAMPLE_ID
,      SAMPLE_TIME
,      SESSION_ID
,      SESSION_SERIAL#
,      SESSION_TYPE
,      FLAGS
,      USER_ID
,      SQL_ID
,      IS_SQLID_CURRENT
,      SQL_CHILD_NUMBER
,      SQL_OPCODE
,      SQL_OPNAME
,      FORCE_MATCHING_SIGNATURE
,      TOP_LEVEL_SQL_ID
,      TOP_LEVEL_SQL_OPCODE
,      SQL_PLAN_HASH_VALUE
,      SQL_FULL_PLAN_HASH_VALUE
,      SQL_ADAPTIVE_PLAN_RESOLVED
,      SQL_PLAN_LINE_ID
,      SQL_PLAN_OPERATION
,      SQL_PLAN_OPTIONS
,      SQL_EXEC_ID
,      SQL_EXEC_START
,      PLSQL_ENTRY_OBJECT_ID
,      PLSQL_ENTRY_SUBPROGRAM_ID
,      PLSQL_OBJECT_ID
,      PLSQL_SUBPROGRAM_ID
,      QC_INSTANCE_ID
,      QC_SESSION_ID
,      QC_SESSION_SERIAL#
,      PX_FLAGS
,      EVENT
,      EVENT_ID
,      SEQ#
,      P1TEXT
,      P1
,      P2TEXT
,      P2
,      P3TEXT
,      P3
,      WAIT_CLASS
,      WAIT_CLASS_ID
,      WAIT_TIME
,      SESSION_STATE
,      TIME_WAITED
,      BLOCKING_SESSION_STATUS
,      BLOCKING_SESSION
,      BLOCKING_SESSION_SERIAL#
,      BLOCKING_INST_ID
,      BLOCKING_HANGCHAIN_INFO
,      CURRENT_OBJ#
,      CURRENT_FILE#
,      CURRENT_BLOCK#
,      CURRENT_ROW#
,      TOP_LEVEL_CALL#
,      TOP_LEVEL_CALL_NAME
,      CONSUMER_GROUP_ID
,      XID
,      REMOTE_INSTANCE#
,      TIME_MODEL
,      IN_CONNECTION_MGMT
,      IN_PARSE
,      IN_HARD_PARSE
,      IN_SQL_EXECUTION
,      IN_PLSQL_EXECUTION
,      IN_PLSQL_RPC
,      IN_PLSQL_COMPILATION
,      IN_JAVA_EXECUTION
,      IN_BIND
,      IN_CURSOR_CLOSE
,      IN_SEQUENCE_LOAD
,      IN_INMEMORY_QUERY
,      IN_INMEMORY_POPULATE
,      IN_INMEMORY_PREPOPULATE
,      IN_INMEMORY_REPOPULATE
,      IN_INMEMORY_TREPOPULATE
,      CAPTURE_OVERHEAD
,      REPLAY_OVERHEAD
,      IS_CAPTURED
,      IS_REPLAYED
,      SERVICE_HASH
,      PROGRAM
,      MODULE
,      ACTION
,      CLIENT_ID
,      MACHINE
,      PORT
,      ECID
,      DBREPLAY_FILE_ID
,      DBREPLAY_CALL_COUNTER
,      TM_DELTA_TIME
,      TM_DELTA_CPU_TIME
,      TM_DELTA_DB_TIME
,      DELTA_TIME
,      DELTA_READ_IO_REQUESTS
,      DELTA_WRITE_IO_REQUESTS
,      DELTA_READ_IO_BYTES
,      DELTA_WRITE_IO_BYTES
,      DELTA_INTERCONNECT_IO_BYTES
,      PGA_ALLOCATED
,      TEMP_SPACE_ALLOCATED
,      DBOP_NAME
,      DBOP_EXEC_ID
,      CON_DBID
,      CON_ID
FROM SYS.DBA_HIST_ACTIVE_SESS_HISTORY;

Dependencies

[top of page]

SYS.DBA_HIST_ACTIVE_SESS_HISTORY references the following:

SchemaSYS
ViewINT$DBA_HIST_ACT_SESS_HISTORY
SYS.DBA_HIST_ACTIVE_SESS_HISTORY is referenced by following:

SchemaPUBLIC
SynonymDBA_HIST_ACTIVE_SESS_HISTORY
SchemaSYS
Package BodyDBMS_SPACE - show dependent code
Package BodyDBMS_SWRF_REPORT_INTERNAL - show dependent code
Package BodyDBMS_WORKLOAD_REPLAY - show dependent code
Package BodyDBMS_WRR_INTERNAL - show dependent code
TYPE BODYWRI$_ADV_OBJSPACE_TREND_T