常用的等待事件以及AWI性能视图

db file scatter read

db file sequential read

log file sync

log file switch(archiving needed)

log file switch(checkpoint incompelete)

buffer busy wait

enqueue (lock)

 

 

v$event_name

v$system_event 所有进程经历的等待事件的汇总

v$session_event 自实例启动以来每个会话所经历的等待事件的汇总

v$session_wait 当前会话的正经历的等待事件，很重要，包含等待次数信息

 

v$session_wait_history 10条记录

v$active_session_history 查看一天

v$system_wait_class

v$session_wait_class