ASH Exploding Across Versions

December 17th, 2011

 

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#


Uncategorized

  1. Trackbacks

  2. No trackbacks yet.
  1. Comments

  2. No comments yet.
You must be logged in to post a comment.