RE: Wait Event
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <avoracle@xxxxxxxxx>, <shivaswamykr@xxxxxxxxx>
- Date: Thu, 22 Feb 2007 22:33:54 -0600
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
Other related posts:
