- enq: HW - contention
- enq: TX - row lock contention
- enq: WF - contention
- log file switch
- log file sync
- log file parallel write
- db file parallel write
- gc current/cr block 2-way/3-way
- Cursor: pin S
- Cursor: pin S wait on X
--查看事件描述 col enqueue for a15 col "enqueue type" for a15 col description for a25 col p1 for a15 col p2 for a15 col p3 for a15 set pagesize 190 SELECT eq_name "Enqueue", ev.name "Enqueue Type", eq.req_description "Description" , ev.parameter1 "P1", ev.parameter2 "P2", ev.parameter3 "P3" FROM v$enqueue_statistics eq, v$event_name ev WHERE eq.event#(+) = ev.event# AND ev.name LIKE '%&event_name%' ORDER BY ev.name;