1 Reply Latest reply: Sep 1, 2013 11:49 AM by Asif Muhammad RSS

    How clear backlog of notifications

    User374733

      EBS: 11.5.10.2

      DB: 10.2.0.4

      Platform: linux 4u5 32-bit

       

      We've configured "Oracle Workflow Notification Mailer" successfully in our TEST instance. Now we are planning to move to Production instance. Before starting I run $FND_TOP/sql/wfver.sql script and got following result:

       

      sqlplus apps/******** @wfver.sql;

      ...

      WF_DEFERRED messages ready:2351236, processed:0
      WF_NOTIFICATION_OUT messages ready:3, processed:0
      WF_ERROR messages ready:381746, processed:0

      ...

       

      I just want to ask is:

       

      Does this huge number of ready events will give any performance issue if I enable workflow in production? How can I know the actual backlog of notifications which will trigger on enabling OWF Mailer. Please advise.