eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.WRH$_ACTIVE_SESSION_HISTORY

Object Details

Object Name:	WRH$_ACTIVE_SESSION_HISTORY
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:
PCT Used:

Primary Key: WRH$_ACTIVE_SESSION_HISTORY_PK

DBID
SNAP_ID
INSTANCE_NUMBER
SAMPLE_ID
SESSION_ID
CON_DBID

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRH$_ACTIVE_SESSION_HISTORY_PK	NORMAL	UNIQUE		DBID SNAP_ID INSTANCE_NUMBER SAMPLE_ID SESSION_ID CON_DBID

Columns

Name	Datatype	Length	Mandatory
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
USER_ID	NUMBER
SQL_ID	VARCHAR2	(13)
SQL_CHILD_NUMBER	NUMBER
SQL_PLAN_HASH_VALUE	NUMBER
SERVICE_HASH	NUMBER
SESSION_TYPE	NUMBER
SQL_OPCODE	NUMBER
QC_SESSION_ID	NUMBER
QC_INSTANCE_ID	NUMBER
CURRENT_OBJ#	NUMBER
CURRENT_FILE#	NUMBER
CURRENT_BLOCK#	NUMBER
SEQ#	NUMBER
EVENT_ID	NUMBER
P1	NUMBER
P2	NUMBER
P3	NUMBER
WAIT_TIME	NUMBER
TIME_WAITED	NUMBER
PROGRAM	VARCHAR2	(64)
MODULE	VARCHAR2	(64)
ACTION	VARCHAR2	(64)
CLIENT_ID	VARCHAR2	(64)
FORCE_MATCHING_SIGNATURE	NUMBER
BLOCKING_SESSION	NUMBER
BLOCKING_SESSION_SERIAL#	NUMBER
XID	RAW	(8)
PLSQL_ENTRY_OBJECT_ID	NUMBER
PLSQL_ENTRY_SUBPROGRAM_ID	NUMBER
PLSQL_OBJECT_ID	NUMBER
PLSQL_SUBPROGRAM_ID	NUMBER
CONSUMER_GROUP_ID	NUMBER
QC_SESSION_SERIAL#	NUMBER
REMOTE_INSTANCE#	NUMBER
SQL_PLAN_LINE_ID	NUMBER
SQL_PLAN_OPERATION#	NUMBER
SQL_PLAN_OPTIONS#	NUMBER
SQL_EXEC_ID	NUMBER
SQL_EXEC_START	DATE
TIME_MODEL	NUMBER
TOP_LEVEL_SQL_ID	VARCHAR2	(13)
TOP_LEVEL_SQL_OPCODE	NUMBER
CURRENT_ROW#	NUMBER
FLAGS	NUMBER
BLOCKING_INST_ID	NUMBER
ECID	VARCHAR2	(64)
TOP_LEVEL_CALL#	NUMBER
MACHINE	VARCHAR2	(64)
PORT	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
DBREPLAY_FILE_ID	NUMBER
DBREPLAY_CALL_COUNTER	NUMBER
PX_FLAGS	NUMBER
CON_DBID	NUMBER		Yes
DBOP_NAME	VARCHAR2	(64)
DBOP_EXEC_ID	NUMBER
SQL_FULL_PLAN_HASH_VALUE	NUMBER
SQL_ADAPTIVE_PLAN_RESOLVED	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#
,      USER_ID
,      SQL_ID
,      SQL_CHILD_NUMBER
,      SQL_PLAN_HASH_VALUE
,      SERVICE_HASH
,      SESSION_TYPE
,      SQL_OPCODE
,      QC_SESSION_ID
,      QC_INSTANCE_ID
,      CURRENT_OBJ#
,      CURRENT_FILE#
,      CURRENT_BLOCK#
,      SEQ#
,      EVENT_ID
,      P1
,      P2
,      P3
,      WAIT_TIME
,      TIME_WAITED
,      PROGRAM
,      MODULE
,      ACTION
,      CLIENT_ID
,      FORCE_MATCHING_SIGNATURE
,      BLOCKING_SESSION
,      BLOCKING_SESSION_SERIAL#
,      XID
,      PLSQL_ENTRY_OBJECT_ID
,      PLSQL_ENTRY_SUBPROGRAM_ID
,      PLSQL_OBJECT_ID
,      PLSQL_SUBPROGRAM_ID
,      CONSUMER_GROUP_ID
,      QC_SESSION_SERIAL#
,      REMOTE_INSTANCE#
,      SQL_PLAN_LINE_ID
,      SQL_PLAN_OPERATION#
,      SQL_PLAN_OPTIONS#
,      SQL_EXEC_ID
,      SQL_EXEC_START
,      TIME_MODEL
,      TOP_LEVEL_SQL_ID
,      TOP_LEVEL_SQL_OPCODE
,      CURRENT_ROW#
,      FLAGS
,      BLOCKING_INST_ID
,      ECID
,      TOP_LEVEL_CALL#
,      MACHINE
,      PORT
,      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
,      DBREPLAY_FILE_ID
,      DBREPLAY_CALL_COUNTER
,      PX_FLAGS
,      CON_DBID
,      DBOP_NAME
,      DBOP_EXEC_ID
,      SQL_FULL_PLAN_HASH_VALUE
,      SQL_ADAPTIVE_PLAN_RESOLVED
FROM SYS.WRH$_ACTIVE_SESSION_HISTORY;

Dependencies

[top of page]

SYS.WRH$_ACTIVE_SESSION_HISTORY does not reference any database object

SYS.WRH$_ACTIVE_SESSION_HISTORY is referenced by following:

SYS: INT$DBA_HIST_ACT_SESS_HISTORY