Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Streams dba_apply_error table rows

441858Feb 14 2013 — edited Feb 19 2013

Oracle 11gR2 OELinux 5 64 bit
Streams local capture

Hi,

I'm not sure what may have caused the issue, but all of a sudden I am seeing thousands of errors in the dba_apply_error table. Many failures for UPDATES, INSERTS and DELETES. The update handlers that I had configured originally are no longer working.
The main concern to me is that the table keeps growing as if it keeps trying to apply records in a loop.

select count(*) from dba_apply_error;

  COUNT(*)
----------
     83283

sys> /

  COUNT(*)
----------
     83284

sys> /

  COUNT(*)
----------
     83296

sys> /

  COUNT(*)
----------
     83297

Any ideas as to what may be causing this?

Even if I delete the transactions that are trying to be applied, it starts to grow again.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2013

Added on Feb 14 2013

#performance-availability, #streams

4 comments

2,826 views