oracleidleeventlist(二)

2014-11-24 17:07:23 · 作者: · 浏览: 1
r messages in the queue 372 Streams AQ: waiting for time management or cleanup tasks 375 Streams AQ: delete acknowledged messages 376 Streams AQ: deallocate messages from Streams Pool 377 Streams AQ: qmn coordinator idle wait 378 Streams AQ: qmn slave idle wait 379 Streams AQ: RAC qmn coordinator idle wait 380 HS message to agent EVENT# NAME ---------- ---------------------------------------------------------------- 386 ASM background timer 392 auto-sqltune: wait graph update 393 WCR: replay client notify 394 WCR: replay clock 396 WCR: replay paused 398 JS external job 407 cell worker idle 已选择95行。

通常意义下,idle event是可以忽略的。但是有时也可以帮助我们解决问题。例如:

Whether or not the event SQL*Net message from client (and SQL*Net message from dblink) should be ignored depends on how the application works. Foreground processes post this event when they wait for instructions from client processes. In other words, the foreground processes are sitting idle waiting for more work to do. For example, a user may run a short query and spend time looking at the result or go out to lunch without logging off. All the while, the foreground process faithfully waits for the user to return, posting the SQL*Net message from client event and increasing the value in the TIME_WAITED column. Therefore, the SQL*Net message from client is the most preva lent event in OLTP systems, and this is why many DBAs choose to ignore this event.

列举几个常用的 none idle 事件,对比上面的idle events。(思考一下 sql net message from client 和more from client的区别),