[Home] [Help] [Dependency Information]
Object Name: | CDB_HIST_ACTIVE_SESS_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Active Session Historical Statistics Information in all containers
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 | container id |
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.CDB_HIST_ACTIVE_SESS_HISTORY;
SYS.CDB_HIST_ACTIVE_SESS_HISTORY does not reference any database object
SYS.CDB_HIST_ACTIVE_SESS_HISTORY is referenced by following:
|
|
|