Oracle Internals

Fixed View: X$ASH

Versions

Oracle Version	X$ Version
10.1.0.3.0	1
10.2.0.1.0	1
11.1.0.6.0	6

Columns

Version 1

Column Name	Data Type
ADDR	RAW(4)
INDX	NUMBER
INST_ID	NUMBER
SAMPLE_ADDR	NUMBER
SAMPLE_ID	NUMBER
SAMPLE_TIME	TIMESTAMP(20)
SESSION_ID	NUMBER
SESSION_SERIAL#	NUMBER
PREV_SESSION_SAMPLE	RAW(4)
USER_ID	NUMBER
SQL_ID	VARCHAR2(13)
SQL_CHILD_NUMBER	NUMBER
SQL_PLAN_HASH_VALUE	NUMBER
FORCE_MATCHING_SIGNATURE	NUMBER
SQL_OPCODE	NUMBER
SERVICE_HASH	NUMBER
SESSION_TYPE	NUMBER
QC_SESSION_ID	NUMBER
QC_INSTANCE_ID	NUMBER
BLOCKING_SESSION	NUMBER
BLOCKING_SESSION_SERIAL#	NUMBER
EVENT	VARCHAR2(64)
EVENT_ID	NUMBER
EVENT#	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
TIME_WAITED	NUMBER
XID	RAW(8)
CURRENT_OBJ#	NUMBER
CURRENT_FILE#	NUMBER
CURRENT_BLOCK#	NUMBER
PROGRAM	VARCHAR2(48)
MODULE	VARCHAR2(48)
ACTION	VARCHAR2(32)
CLIENT_ID	VARCHAR2(64)

Version 6

Column Name	Data Type
ADDR	RAW(4)
INDX	NUMBER
INST_ID	NUMBER
SAMPLE_ADDR	NUMBER
SAMPLE_ID	NUMBER
SAMPLE_TIME	TIMESTAMP(20)
SESSION_ID	NUMBER
SESSION_SERIAL#	NUMBER
PREV_SESSION_SAMPLE	RAW(4)
SESSION_TYPE	NUMBER
FLAGS	NUMBER
USER_ID	NUMBER
SQL_ID	VARCHAR2(13)
SQL_CHILD_NUMBER	NUMBER
SQL_OPCODE	NUMBER
FORCE_MATCHING_SIGNATURE	NUMBER
TOP_LEVEL_SQL_ID	VARCHAR2(13)
TOP_LEVEL_SQL_OPCODE	NUMBER
SQL_PLAN_HASH_VALUE	NUMBER
SQL_PLAN_LINE_ID	NUMBER
SQL_PLAN_LINE_HIDDEN	NUMBER
SQL_PLAN_OPERATION#	NUMBER
SQL_PLAN_OPERATION	VARCHAR2(30)
SQL_PLAN_OPTIONS#	NUMBER
SQL_PLAN_OPTIONS	VARCHAR2(30)
SQL_EXEC_ID	NUMBER
SQL_EXEC_START	DATE
SQL_ROWSRC_INFO	NUMBER
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
EVENT	VARCHAR2(64)
EVENT_ID	NUMBER
EVENT#	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
TIME_WAITED	NUMBER
BLOCKING_SESSION	NUMBER
BLOCKING_SESSION_SERIAL#	NUMBER
CURRENT_OBJ#	NUMBER
CURRENT_FILE#	NUMBER
CURRENT_BLOCK#	NUMBER
CURRENT_ROW#	NUMBER
CONSUMER_GROUP_ID	NUMBER
XID	RAW(8)
REMOTE_INSTANCE#	NUMBER
TIME_MODEL	NUMBER
IN_DBTIME	VARCHAR2(1)
IN_BACKGROUND	VARCHAR2(1)
IN_CONNECTION_MGMT	VARCHAR2(1)
IN_PARSE	VARCHAR2(1)
IN_FAILED_PARSE	VARCHAR2(1)
IN_NOMEM_PARSE	VARCHAR2(1)
IN_HARD_PARSE	VARCHAR2(1)
IN_NO_SHARERS_PARSE	VARCHAR2(1)
IN_BIND_MISMATCH_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)
SERVICE_HASH	NUMBER
PROGRAM	VARCHAR2(48)
MODULE	VARCHAR2(48)
ACTION	VARCHAR2(32)
CLIENT_ID	VARCHAR2(64)

Indexes

Version 1

Version 1 of this fixed view has one index

Index Number	Index Position	Column Name
1	0	SAMPLE_ADDR
1	1	SAMPLE_ID

Version 6

Version 6 of this fixed view has one index

Index Number	Index Position	Column Name
1	0	SAMPLE_ADDR
1	1	SAMPLE_ID