美创科技技术社区

注册

 

发新话题 回复该主题

v$active_session_history视图 [复制链接]

1#




ASH的核心视图:
v$active_session_history
SAMPLE_ID
No comments exist for the SAMPLE_ID column of the V$ACTIVE_SESSION_HISTORY table.
SAMPLE_TIME
No comments exist for the SAMPLE_TIME column of the V$ACTIVE_SESSION_HISTORY table.
SESSION_ID
No comments exist for the SESSION_ID column of the V$ACTIVE_SESSION_HISTORY table.
SESSION_SERIAL#
No comments exist for the SESSION_SERIAL# column of the V$ACTIVE_SESSION_HISTORY table.
SESSION_TYPE
No comments exist for the SESSION_TYPE column of the V$ACTIVE_SESSION_HISTORY table.
FLAGS
No comments exist for the FLAGS column of the V$ACTIVE_SESSION_HISTORY table.
USER_ID
No comments exist for the USER_ID column of the V$ACTIVE_SESSION_HISTORY table.
SQL_ID
No comments exist for the SQL_ID column of the V$ACTIVE_SESSION_HISTORY table.
SQL_CHILD_NUMBER
No comments exist for the SQL_CHILD_NUMBER column of the V$ACTIVE_SESSION_HISTORY table.
SQL_OPCODE
No comments exist for the SQL_OPCODE column of the V$ACTIVE_SESSION_HISTORY table.
FORCE_MATCHING_SIGNATURE
No comments exist for the FORCE_MATCHING_SIGNATURE column of the V$ACTIVE_SESSION_HISTORY table.
TOP_LEVEL_SQL_ID
No comments exist for the TOP_LEVEL_SQL_ID column of the V$ACTIVE_SESSION_HISTORY table.
TOP_LEVEL_SQL_OPCODE
No comments exist for the TOP_LEVEL_SQL_OPCODE column of the V$ACTIVE_SESSION_HISTORY table.
SQL_PLAN_HASH_VALUE
No comments exist for the SQL_PLAN_HASH_VALUE column of the V$ACTIVE_SESSION_HISTORY table.
SQL_PLAN_LINE_ID
No comments exist for the SQL_PLAN_LINE_ID column of the V$ACTIVE_SESSION_HISTORY table.
SQL_PLAN_OPERATION
No comments exist for the SQL_PLAN_OPERATION column of the V$ACTIVE_SESSION_HISTORY table.
SQL_PLAN_OPTIONS
No comments exist for the SQL_PLAN_OPTIONS column of the V$ACTIVE_SESSION_HISTORY table.
SQL_EXEC_ID
No comments exist for the SQL_EXEC_ID column of the V$ACTIVE_SESSION_HISTORY table.
SQL_EXEC_START
No comments exist for the SQL_EXEC_START column of the V$ACTIVE_SESSION_HISTORY table.
PLSQL_ENTRY_OBJECT_ID
No comments exist for the PLSQL_ENTRY_OBJECT_ID column of the V$ACTIVE_SESSION_HISTORY table.
PLSQL_ENTRY_SUBPROGRAM_ID
No comments exist for the PLSQL_ENTRY_SUBPROGRAM_ID column of the V$ACTIVE_SESSION_HISTORY table.
PLSQL_OBJECT_ID
No comments exist for the PLSQL_OBJECT_ID column of the V$ACTIVE_SESSION_HISTORY table.
PLSQL_SUBPROGRAM_ID
No comments exist for the PLSQL_SUBPROGRAM_ID column of the V$ACTIVE_SESSION_HISTORY table.
QC_INSTANCE_ID
No comments exist for the QC_INSTANCE_ID column of the V$ACTIVE_SESSION_HISTORY table.
QC_SESSION_ID
No comments exist for the QC_SESSION_ID column of the V$ACTIVE_SESSION_HISTORY table.
QC_SESSION_SERIAL#
No comments exist for the QC_SESSION_SERIAL# column of the V$ACTIVE_SESSION_HISTORY table.
EVENT
No comments exist for the EVENT column of the V$ACTIVE_SESSION_HISTORY table.
EVENT_ID
No comments exist for the EVENT_ID column of the V$ACTIVE_SESSION_HISTORY table.
EVENT#
No comments exist for the EVENT# column of the V$ACTIVE_SESSION_HISTORY table.
SEQ#
No comments exist for the SEQ# column of the V$ACTIVE_SESSION_HISTORY table.
P1TEXT
No comments exist for the P1TEXT column of the V$ACTIVE_SESSION_HISTORY table.
P1
No comments exist for the P1 column of the V$ACTIVE_SESSION_HISTORY table.
P2TEXT
No comments exist for the P2TEXT column of the V$ACTIVE_SESSION_HISTORY table.
P2
No comments exist for the P2 column of the V$ACTIVE_SESSION_HISTORY table.
P3TEXT
No comments exist for the P3TEXT column of the V$ACTIVE_SESSION_HISTORY table.
P3
No comments exist for the P3 column of the V$ACTIVE_SESSION_HISTORY table.
WAIT_CLASS
No comments exist for the WAIT_CLASS column of the V$ACTIVE_SESSION_HISTORY table.
WAIT_CLASS_ID
No comments exist for the WAIT_CLASS_ID column of the V$ACTIVE_SESSION_HISTORY table.
WAIT_TIME
No comments exist for the WAIT_TIME column of the V$ACTIVE_SESSION_HISTORY table.
SESSION_STATE
No comments exist for the SESSION_STATE column of the V$ACTIVE_SESSION_HISTORY table.
TIME_WAITED
No comments exist for the TIME_WAITED column of the V$ACTIVE_SESSION_HISTORY table.
BLOCKING_SESSION_STATUS
No comments exist for the BLOCKING_SESSION_STATUS column of the V$ACTIVE_SESSION_HISTORY table.
BLOCKING_SESSION
No comments exist for the BLOCKING_SESSION column of the V$ACTIVE_SESSION_HISTORY table.
BLOCKING_SESSION_SERIAL#
No comments exist for the BLOCKING_SESSION_SERIAL# column of the V$ACTIVE_SESSION_HISTORY table.
CURRENT_OBJ#
No comments exist for the CURRENT_OBJ# column of the V$ACTIVE_SESSION_HISTORY table.
CURRENT_FILE#
No comments exist for the CURRENT_FILE# column of the V$ACTIVE_SESSION_HISTORY table.
CURRENT_BLOCK#
No comments exist for the CURRENT_BLOCK# column of the V$ACTIVE_SESSION_HISTORY table.
CURRENT_ROW#
No comments exist for the CURRENT_ROW# column of the V$ACTIVE_SESSION_HISTORY table.
CONSUMER_GROUP_ID
No comments exist for the CONSUMER_GROUP_ID column of the V$ACTIVE_SESSION_HISTORY table.
XID
No comments exist for the XID column of the V$ACTIVE_SESSION_HISTORY table.
REMOTE_INSTANCE#
No comments exist for the REMOTE_INSTANCE# column of the V$ACTIVE_SESSION_HISTORY table.
IN_CONNECTION_MGMT
No comments exist for the IN_CONNECTION_MGMT column of the V$ACTIVE_SESSION_HISTORY table.
IN_PARSE
No comments exist for the IN_PARSE column of the V$ACTIVE_SESSION_HISTORY table.
IN_HARD_PARSE
No comments exist for the IN_HARD_PARSE column of the V$ACTIVE_SESSION_HISTORY table.
IN_SQL_EXECUTION
No comments exist for the IN_SQL_EXECUTION column of the V$ACTIVE_SESSION_HISTORY table.
IN_PLSQL_EXECUTION
No comments exist for the IN_PLSQL_EXECUTION column of the V$ACTIVE_SESSION_HISTORY table.
IN_PLSQL_RPC
No comments exist for the IN_PLSQL_RPC column of the V$ACTIVE_SESSION_HISTORY table.
IN_PLSQL_COMPILATION
No comments exist for the IN_PLSQL_COMPILATION column of the V$ACTIVE_SESSION_HISTORY table.
IN_JAVA_EXECUTION
No comments exist for the IN_JAVA_EXECUTION column of the V$ACTIVE_SESSION_HISTORY table.
IN_BIND
No comments exist for the IN_BIND column of the V$ACTIVE_SESSION_HISTORY table.
IN_CURSOR_CLOSE
No comments exist for the IN_CURSOR_CLOSE column of the V$ACTIVE_SESSION_HISTORY table.
SERVICE_HASH
No comments exist for the SERVICE_HASH column of the V$ACTIVE_SESSION_HISTORY table.
PROGRAM
No comments exist for the PROGRAM column of the V$ACTIVE_SESSION_HISTORY table.
MODULE
No comments exist for the MODULE column of the V$ACTIVE_SESSION_HISTORY table.
ACTION
No comments exist for the ACTION column of the V$ACTIVE_SESSION_HISTORY table.
CLIENT_ID
No comments exist for the CLIENT_ID column of the V$ACTIVE_SESSION_HISTORY table
视图定义:
SELECT  /*+ no_merge ordered use_nl(s,a) */ a.inst_id, s.sample_id, s.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.sql_opcode, decode(a.plsql_entry_object_id,0,to_number(NULL),a.plsql_entry_object_id), decode(a.plsql_entry_object_id,0,to_number(NULL),a.plsql_entry_subprogram_id), decode(a.plsql_object_id,0,to_number(NULL),a.plsql_object_id), decode(a.plsql_object_id,0,to_number(NULL),a.plsql_subprogram_id), a.service_hash, decode(a.session_type, 1,’FOREGROUND’, 2,’BACKGROUND’, ‘UNKNOWN’), decode(a.wait_time, 0, ‘WAITING’, ‘ON CPU’), decode(a.qc_session_id, 0, to_number(NULL), a.qc_session_id), decode(a.qc_session_id, 0, to_number(NULL), a.qc_instance_id), (case when a.blocking_session between 4294967291 and 4294967295         then to_number(NULL)       else a.blocking_session  end), (case when a.blocking_session = 4294967295         then ‘UNKNOWN’       when a.blocking_session = 4294967294         then ‘GLOBAL’       when a.blocking_session = 4294967293         then ‘UNKNOWN’       when a.blocking_session = 4294967292         then ‘NO HOLDER’       when a.blocking_session = 4294967291         then ‘NOT IN WAIT’       else ‘VALID’  end), (case when a.blocking_session between 4294967291 and 4294967295         then to_number(NULL)       else a.blocking_session_serial#  end), decode(a.wait_time, 0, a.event,    NULL), decode(a.wait_time, 0, a.event_id, NULL), decode(a.wait_time, 0, a.event#,   NULL), a.seq#, a.p1text, a.p1, a.p2text, a.p2, a.p3text, a.p3, decode(a.wait_time, 0, a.wait_class,    NULL), decode(a.wait_time, 0, a.wait_class_id, NULL), a.wait_time, a.time_waited, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id FROM  x$kewash s, x$ash a WHERE s.sample_addr = a.sample_addr and       s.sample_id   = a.sample_id   and       s.sample_time = a.sample_time

分享 转发
TOP
发新话题 回复该主题