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
alter system set "_awr_disabled_flush_tables" = 'WRH$_DATAFILE' sid='*';
gcs remote message
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/，如需转载，请注明出处，否则将追究法律责任。