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.