ITPub博客

首页 > Linux操作系统 > Linux操作系统 >

原创 Linux操作系统 作者:psufnxk2000 时间:2013-11-04 23:19:49 0 删除 编辑


enq: WF - contention
MMON is attempting the auto flush function, which means that we are trying to flush the ASH data into the AWR for the historical repository. We take out the WF enqueue for doing this
MMON自动刷新功能,想把ASH里的数据写到awr中。


有建快照时等待这个事件的情况
有hang着等待这个事件
alter system set "_awr_disabled_flush_tables" = 'WRH$_DATAFILE' sid='*';






gcs remote message
这是一个空闲等待,可以忽略
MOS 220970.1
I am seeing the wait events 'ges remote message', 'gcs remote message', and/or 'gcs for action'. What should I do about these?
These are idle wait events and can be safetly ignored. 
The 'ges remote message' might show up in a 9.0.1 statspack report as one of the top wait events.
To have this wait event not show up you can add this event to the PERFSTAT.STATS$IDLE_EVENT table so that it is not listed in Statspack reports.




Streams AQ: waiting for messages in the queue
DIAG idle wait:Those waits indicate that your Parallel Query Slaves are waiting for 'orders' to do something
Streams AQ: waiting for time management or cleanup tasks
jobq slave wait
也是一个空闲等待事件

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25099483/viewspace-775666/,如需转载,请注明出处,否则将追究法律责任。

上一篇: sequene Cache Size
下一篇: parallel_max_servers
请登录后发表评论 登录
全部评论

注册时间:2011-05-31

  • 博文量
    215
  • 访问量
    616616