那是不是我們每當遇到性能問題的時候都要patch到9.2.0.3呢?
我們已經知道他的真實情況依然在v$session_wait的p1、p2、p3參數里體現,所以,我們可以根據這些參數,找出這個null event究竟是什么等待事件。
相關信息:
1. lck processes to pick up extra or missed 'posts' (messages)。
in all cases that can be identified the wait time is zero,
although on most ports this is changed to 1/100th second in
order to force the process to be rescheduled.
2. multiple db writers.
two cases:
- when the master has sent i/o requests to the slaves, it
waits on this event for up to 6 seconds until the slaves
signal that the i/o is complete.
- the slaves wait on this event for up to 3 seconds whilst
waiting for requests from the master db writer.
目前已經被證實的會涉及到null event
的等待事件還有有sql.net message to client、
db file scattered (or sequential) read
MSN:
