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.