介绍

V$SESSION_EVENT视图提供了查询当前数据库中会话等待事件的信息。
对于那些不支持快速计时机制(fast timing mechanism)的操作系统上，该视图的TIME_WAIT和AVERAGE_WAIT列始终为0。
如果想要该视图能够反映真实的等待时间，则必须将TIMED_STATISTICS参数设置为TRUE。该值设置为TRUE后，会对性能有一定影响。(性能影响较小)

视图详情

字段名	字段类型	描述	译	备注
SID	NUMBER	ID of the session	会话ID
EVENT	VARCHAR2(64)	Name of the wait event	等待事件的名称
TOTAL_WAITS	NUMBER	Total number of waits for the event by the session	会话内等待事件的总次数
TOTAL_TIMEOUTS	NUMBER	Total number of timeouts for the event by the session	会话内等待事件的超时总次数
TIME_WAITED	NUMBER	Total amount of time waited for the event by the session (in hundredths of a second)	会话内等待事件的总时长(百分之一秒)
AVERAGE_WAIT	NUMBER	Average amount of time waited for the event by the session (in hundredths of a second)	会话内等待事件的平均时长(百分之一秒)
MAX_WAIT	NUMBER	Maximum time waited for the event by the session (in hundredths of a second)	会话内等待事件的最大时长(百分之一秒)
TIME_WAITED_MICRO	NUMBER	Total amount of time waited for the event by the session (in microseconds)	会话内等待事件的总时长，以微妙为单位
EVENT_ID	NUMBER	Identifier of the wait event	等待事件的标识符
WAIT_CLASS_ID	NUMBER	Identifier of the class of the wait event	等待事件类别的标识符
WAIT_CLASS#	NUMBER	Number of the class of the wait event	等待事件的类别号
WAIT_CLASS	VARCHAR2(64)	Name of the class of the wait event	等待事件的类别名称