0 Replies Latest reply: Dec 24, 2011 5:36 AM by 540301 RSS

    Streams Apply is spilling the messages

    540301
      Hi Experts,

      I have setup the streams one way at schema level, when I started the apply first time, it is spilling the messages. Using both single database instances version 10.2.0.2.

      select APPLY_NAME,STATE,TOTAL_MESSAGES_DEQUEUED,TOTAL_MESSAGES_SPILLED,DEQUEUE_TIME from V$STREAMS_APPLY_READER;
      STREAMS_APPLY SPILLING 5788 5783 24-Dec-2011 01:21:26 AM

      I ran the following SQL and it is saying no message has been applied.

      SELECT APPLY_NAME, TOTAL_RECEIVED, TOTAL_APPLIED, TOTAL_ERRORS, (TOTAL_ASSIGNED - (TOTAL_ROLLBACKS + TOTAL_APPLIED)) BEING_APPLIED FROM V$STREAMS_APPLY_COORDINATOR;


      Not sure why streams apply is spilling the messages, there is no apply error. TOTAL_MESSAGES_DEQUEUED value is increasing which seems that that the propagation is sending the messages. Any suggestion/advise would be really helpful. Mean time googling arround.

      Regards
      -Samar-