很多人也許并不清楚,null event其實不是空事件,因為不是沒有等待事件,而是Oracle忘記了剛才等待的事件的名字具體是什么了,但卻保留了該事件的真實情況。Oracle的開發人員直到9.2.0.3才更新了這些事件的名稱。
那是不是我們每當遇到性能問題的時候都要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:
posted on 2008-02-15 01:03
kylixlu 閱讀(189)
評論(0) 編輯 收藏 所屬分類:
Database