streams issue

Hi all:

We have recently implemented an application with streams on Linux using
Oracle 10.2.0.2.
Since last I am seeing apply process failing every few minutes with the
following error in the alert log:

ORA-10388: parallel query server interrupt (failure)
Sat Sep 23 02:06:34 2006
Streams APPLY A001 with pid=40, OS id=32280 stopped
Sat Sep 23 02:06:34 2006
Errors in file /opt/oracle/admin/pihs10/bdump/pihs101_a001_32280.trc:
ORA-12801: error signaled in parallel query server P000, instance
rwlp75l1.ihs.discoverfinancial.com:pihs101 (1)
ORA-00001: unique constraint (SYS.I_STREAMS_APPLY_SPILL_TXN) violated

I have searched metalink but did not find any relevant info. Has anyone
seen that error and has  an explanation and a fix?

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l


Other related posts: