数据库

img FrankvsYang

Oracle9i中一个特殊等待事件--null event

发表于2004/10/26 17:40:00  1118人阅读

null event不是空事件,不是没有等待事件,而是Oracle忘记了刚才等待的事件的名字是什么了,但保留了该事件的真实情况。Oracle 的开发人员直到9.2.0.3才更新了这些事件名称。
那是不是我们每当遇到性能问题的时候都要patch到9.2.0.3呢?
我们已经知道他的真实情况依然在v$session_wait的P1、P2、P3参数里体现,所以,我们可以从这些参数顺藤摸瓜,找出这个null event 到底是什么等待事件。

下面是ITPUB上COPY过来的一些信息:
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

待续

===========================
自己机器上的测试:
[code]
SQL> select sid,event,p1,p2,p3 from v$session_wait;

       SID EVENT                                  P1         P2         P3
---------- ------------------------------ ---------- ---------- ----------
        11 null event                     2056367224        155          0
        12 null event                     1111838976          1          0
         1 pmon timer                            300          0          0
         2 rdbms ipc message                     300          0          0
         3 rdbms ipc message                     300          0          0
         6 rdbms ipc message                  180000          0          0
         7 rdbms ipc message                     300          0          0
         4 rdbms ipc message                     300          0          0
         5 smon timer                            300          0          0
         9 SQL*Net message from client    1111838976          1          0
         8 wakeup time manager                     0          0          0

11 rows selected.
[/code]
sid为12的null event的等待事件与sid为9的是一样的--”SQL*Net message from client“
============================================

阅读全文
0 0

相关文章推荐

img
取 消
img