Re: Wait Event

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Tue, 20 Feb 2007 15:48:21 -0800 (PST)
Message-ID: <817720.56913.qm@web31902.mail.mud.yahoo.com>

IIRC I have seen this when the delay_seconds in the push call to dbms_defer_sys package had a large value and is not the default of 0.    

  -Fairlie

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

          Fairlie Rego
Senior Oracle Consultant
  http://www.linkedin.com/in/fairlierego   

  http://el-caro.blogspot.com/
  M: +61 402 792 405      

---

Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 20 2007 - 17:48:21 CST