[Home] [Help] [Dependency Information]
Object Name: | WRH$_ACTIVE_SESSION_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRH$_ACTIVE_SESSION_HISTORY_PK | NORMAL | UNIQUE |
DBID
SNAP_ID INSTANCE_NUMBER SAMPLE_ID SESSION_ID CON_DBID |
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 | |||
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 |
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;
SYS.WRH$_ACTIVE_SESSION_HISTORY does not reference any database object
SYS.WRH$_ACTIVE_SESSION_HISTORY is referenced by following:
|
|
|