Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: Wait Event

fairlie rego

2007-02-20

Replies:

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@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
M: +61 402 792 405
 


Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.