Isn't it great the way Oracle tells people that things that consume end-user response time can be ignored? Cool, let's just call the users up and tell them the good news: they can ignore that particular part of what they had previously considered a performance problem. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Hotsos Symposium 2007 / March 4-8 / Dallas Visit www.hotsos.com for curriculum and schedule details... ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Anurag Varma Sent: Wednesday, February 21, 2007 10:15 PM To: shivaswamykr@xxxxxxxxx Cc: Oracle-L Freelists Subject: Re: Wait Event On 2/20/07, Shivaswamy Raghunath <shivaswamykr@xxxxxxxxx> wrote: Hello. My environment is HP UX 11i. DB Version 10.1.0.4. On this database I have Oracle replication is in action, replicating certain tables to another database. I have a very high occurance and time for the event knpc_anq_AwaitNonemptyQueue. I could not get much useful info on the event anywhere. Appears to be an idle event. But, jsut wanted to make sure. If you have any info, pointer etc. can you please let me know? The event is reported against SYSTEM.DEF$_DESTINATION_PRIMARY. Total Wait time is 10,933,039,621. TIA, Shiva I had opened an SR about this long time back. I don't remember the exact reply but it was something to this effect: * Its an IDLE wait event. Can be ignored. * Its either what Fairlie mentions it to be or connected with the parallel push option. I remember when I changed push to serial (once a minute), the wait event had disappeared. -- Anurag Varma