Re: Wait Event

  • From: fairlie rego <fairlie_r@xxxxxxxxx>
  • To: shivaswamykr@xxxxxxxxx
  • Date: Tue, 20 Feb 2007 15:48:21 -0800 (PST)

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@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




          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.

Other related posts: