I sometimes forget which versions of ASH have which fields, so here is a bit of a graphic and textual cheat sheet. (see https://sites.google.com/site/oraclemonitor/dba_hist_active_sess_history for some queries on ASH)

 

 

10.2.0
10.2.0.3
11.1.0
11.2.0 (http://download.oracle.com/docs/cd/E11882_01/server.112/e10820/dynviews_1007.htm#I1030299)
SAMPLE_IDSAMPLE_IDSAMPLE_IDSAMPLE_ID
SAMPLE_TIMESAMPLE_TIMESAMPLE_TIMESAMPLE_TIME
SESSION_IDSESSION_IDSESSION_IDSESSION_ID
SESSION_SERIAL#SESSION_SERIAL#SESSION_SERIAL#SESSION_SERIAL#
SESSION_TYPESESSION_TYPESESSION_TYPESESSION_TYPE
USER_IDUSER_IDUSER_IDUSER_ID
QC_INSTANCE_IDQC_INSTANCE_IDQC_INSTANCE_IDQC_INSTANCE_ID
QC_SESSION_IDQC_SESSION_IDQC_SESSION_IDQC_SESSION_ID
SERVICE_HASHSERVICE_HASHSERVICE_HASHSERVICE_HASH
PROGRAMPROGRAMPROGRAMPROGRAM
MODULEMODULEMODULEMODULE
ACTIONACTIONACTIONACTION
CLIENT_IDCLIENT_IDCLIENT_IDCLIENT_ID
QC_SESSION_SERIAL#QC_SESSION_SERIAL#
CONSUMER_GROUP_IDCONSUMER_GROUP_ID

MACHINE

PORT
SQL_IDSQL_IDSQL_IDSQL_ID
SQL_CHILD_NUMBERSQL_CHILD_NUMBERSQL_CHILD_NUMBERSQL_CHILD_NUMBER
SQL_OPCODESQL_OPCODESQL_OPCODESQL_OPCODE
SQL_PLAN_HASH_VALUESQL_PLAN_HASH_VALUESQL_PLAN_HASH_VALUESQL_PLAN_HASH_VALUE
XIDXIDXIDXID
FORCE_MATCHING_SIGNATUREFORCE_MATCHING_SIGNATUREFORCE_MATCHING_SIGNATUREFORCE_MATCHING_SIGNATURE

PLSQL_ENTRY_OBJECT_IDPLSQL_ENTRY_OBJECT_IDPLSQL_ENTRY_OBJECT_ID

PLSQL_ENTRY_SUBPROGRAM_IDPLSQL_ENTRY_SUBPROGRAM_IDPLSQL_ENTRY_SUBPROGRAM_ID
PLSQL_OBJECT_IDPLSQL_OBJECT_IDPLSQL_OBJECT_ID

PLSQL_SUBPROGRAM_IDPLSQL_SUBPROGRAM_IDPLSQL_SUBPROGRAM_ID

TOP_LEVEL_SQL_IDTOP_LEVEL_SQL_ID

TOP_LEVEL_SQL_OPCODETOP_LEVEL_SQL_OPCODE

SQL_PLAN_LINE_IDSQL_PLAN_LINE_ID

SQL_PLAN_OPERATIONSQL_PLAN_OPERATION

SQL_PLAN_OPTIONSSQL_PLAN_OPTIONS

SQL_EXEC_IDSQL_EXEC_ID

SQL_EXEC_STARTSQL_EXEC_START

IN_CONNECTION_MGMTIN_CONNECTION_MGMT
IN_PARSEIN_PARSE
IN_HARD_PARSEIN_HARD_PARSE
IN_SQL_EXECUTIONIN_SQL_EXECUTION

IN_PLSQL_EXECUTIONIN_PLSQL_EXECUTION

IN_PLSQL_RPCIN_PLSQL_RPC

IN_PLSQL_COMPILATIONIN_PLSQL_COMPILATION

IN_JAVA_EXECUTIONIN_JAVA_EXECUTION

IN_BINDIN_BIND

IN_CURSOR_CLOSEIN_CURSOR_CLOSE

IN_SEQUENCE_LOAD

TOP_LEVEL_CALL#

TOP_LEVEL_CALL_NAME
IS_SQLID_CURRENT
SQL_OPNAME
EVENTEVENTEVENTEVENT
EVENT_IDEVENT_IDEVENT_IDEVENT_ID
EVENT#EVENT#EVENT#EVENT#
SEQ#SEQ#SEQ#SEQ#
P1P1P1P1
P2P2P2P2
P3P3P3P3
WAIT_TIMEWAIT_TIMEWAIT_TIMEWAIT_TIME
SESSION_STATESESSION_STATESESSION_STATESESSION_STATE
TIME_WAITEDTIME_WAITEDTIME_WAITEDTIME_WAITED
CURRENT_OBJ#CURRENT_OBJ#CURRENT_OBJ#CURRENT_OBJ#
CURRENT_FILE#CURRENT_FILE#CURRENT_FILE#CURRENT_FILE#
CURRENT_BLOCK#CURRENT_BLOCK#CURRENT_BLOCK#CURRENT_BLOCK#
P1TEXTP1TEXTP1TEXTP1TEXT
P2TEXTP2TEXTP2TEXTP2TEXT
P3TEXTP3TEXTP3TEXTP3TEXT
WAIT_CLASSWAIT_CLASSWAIT_CLASSWAIT_CLASS
WAIT_CLASS_IDWAIT_CLASS_IDWAIT_CLASS_IDWAIT_CLASS_ID

CURRENT_ROW#CURRENT_ROW#
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_ALLOCATE
BLOCKING_SESSIONBLOCKING_SESSIONBLOCKING_SESSION_STATUSBLOCKING_SESSION_STATUS
BLOCKING_SESSION_STATUSBLOCKING_SESSION_STATUSBLOCKING_SESSIONBLOCKING_SESSION
BLOCKING_SESSION_SERIAL#BLOCKING_SESSION_SERIAL#BLOCKING_SESSION_SERIAL#BLOCKING_SESSION_SERIAL#

BLOCKING_INST_ID

BLOCKING_HANGCHAIN_INFO
FLAGSFLAGS
REMOTE_INSTANCE#REMOTE_INSTANCE#

TIME_MODEL
IS_AWR_SAMPLE

ECID
CAPTURE_OVERHEAD
REPLAY_OVERHEAD
IS_CAPTURED
IS_REPLAYED

10.1

SAMPLE_ID

SAMPLE_TIME

SESSION_ID

SESSION_SERIAL#

SESSION_TYPE

USER_ID

QC_SESSION_ID

QC_INSTANCE_ID

SERVICE_HASH

PROGRAM

MODULE

ACTION

CLIENT_ID

SQL_ID

SQL_CHILD_NUMBER

SQL_OPCODE

SQL_PLAN_HASH_VALUE

EVENT

EVENT_ID

EVENT#

SEQ#

P1

P2

P3

WAIT_TIME

SESSION_STATE

TIME_WAITED

CURRENT_OBJ#

CURRENT_FILE#

CURRENT_BLOCK#

Kyle Hailey
Uncategorized