ASH Exploding Across Versions
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# |
Trackbacks
Comments