Oracle OWI等待事件视图(v$session_wait/v$session_event/v$system_event)(三)
----- -----------------
Application enq: RO - fast object reuse 99 1 393 4 20130410 20:22:43
Application enq: TX - row lock contention 382 379 111,476 292 20130410 20:22:43
Concurrency enq: TX - index contention 3 0 28 9 20130410 20:22:43
Configuration enq: HW - contention 27 1 592 22 20130410 20:22:43
Other latch: enqueue hash chains 5 0 6 1 20130410 20:22:43
Other enq: FB - contention 1 0 10 10 20130410 20:22:43
Other enq: TX - contention 4 0 158 39 20130410 20:22:43
Other enq: CF - contention 6 5 1,556 259 20130410 20:22:43
8 rows selected.
--当输入ALL时，该实例的所有等待事件被列出
goex_admin@SYBO2SZ> @wait_event_inst_lvl
Enter value for input_event_name: ALL
Enter value for input_event_name: ALL
WAIT_CLASS EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT STARTUP_TIME
-------------------- ------------------------------ ------------ -------------- ----------- ------------- -----------------
Application SQL*Net break/reset to client 99 0 1 0 20130410 20:22:43
Application enq: RO - fast object reuse 99 1 393 4 20130410 20:22:43
Application enq: TX - row lock contention 382 379 111,476 292 20130410 20:22:43
Commit log file sync 33,165 3,788 798,189 24 20130410 20:22:43
Concurrency latch: library cache pin 5 0 0 0 20130410 20:22:43
Concurrency latch: library cache lock 5 0 15 3 20130410 20:22:43
Concurrency enq: TX - index contention 3 0 28 9 20130410 20:22:43
Concurrency cursor: mutex S 6,737 0 29 0 20130410 20:22:43
goex_admin@SYBO2SZ> @wait_event_inst_lvl
Enter value for input_event_name: ALL
Enter value for input_event_name: ALL
WAIT_CLASS EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT STARTUP_TIME
-------------------- ------------------------------ ------------ -------------- ----------- ------------- -----------------
Application SQL*Net break/reset to client 99 0 1 0 20130410 20:22:43
Application enq: RO - fast object reuse 99 1 393 4 20130410 20:22:43
Application enq: TX - row lock contention 382 379 111,476 292 20130410 20:22:43
Commit log file sync 33,165 3,788 798,189 24 20130410 20:22:43
......................
Concurrency latch: library cache pin 5 0 0 0 20130410 20:22:43
Concurrency latch: library cache lock 5 0 15 3 20130410 20:22:43
Concurrency enq: TX - index contention 3 0 28 9 20130410 20:22:43
Concurrency cursor: mutex S 6,737 0 29 0 20130410 20:22:43
8、演示中使用到的脚本
[sql]
a、wait_event_by_sid.sql
robin@SZDB:~/dba_scri