Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    4

    Unanswered: Propagation propagate but apply process does not

    My propagation propagates but apply does not get messages. Where is wrong. If any kind hearted people there to solve my problem?

    SELECT p.PROPAGATION_NAME, s.TOTAL_TIME, s.TOTAL_NUMBER, s.TOTAL_BYTES
    FROM DBA_QUEUE_SCHEDULES s, DBA_PROPAGATION p
    WHERE p.DESTINATION_DBLINK = s.DESTINATION
    AND s.SCHEMA = p.SOURCE_QUEUE_OWNER
    AND s.QNAME = p.SOURSQL> SQL> CE_QUEUE_NAME;SQL> SQL> SQL> 2 3 4 5

    Total Time
    Propagation Executing Total Messages Total Bytes
    Name in Seconds Propagated Propagated
    -------------------- ---------- -------------- --------------
    PROP_SFDB_TO_LADB 159 83 69235
    PROP_SFDB_TO_LADB 0 0 0




    SQL> SELECT APPLY_NAME,
    TOTAL_RECEIVED,
    TOTAL_APPLIED,
    TOTAL_ERRORS,
    (TOTAL_ASSIGNED - (TOTAL_ROLLBACKS + TOTAL_APPLIED)) BEING_APPLIED,
    TOTAL_IGNORED
    FROM V$STREAMS_APPLY_COORDINATOR; 2 3 4 5 6 7

    Apply Total Total Total Total Total
    Process Trans Trans Apply Trans Being Trans
    Name Received Applied Errors Applied Ignored
    ---------- --------- --------- ------ ----------- ---------
    APPLY_SRC_ 0 0 0 0 0
    SFDB


    I am ready here to answer your information whatever you need..

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Where is wrong.
    It is OK for me.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2007
    Posts
    4
    It is of course a matter for think who holds knowledge.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •