RE: Wait Event

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anurag Varma Sent: Wednesday, February 21, 2007 10:15 PM To: shivaswamykr_at_gmail.com
Cc: Oracle-L Freelists
Subject: Re: Wait Event    

On 2/20/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> 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 


--
http://www.freelists.org/webpage/oracle-l