Performance Problems with Notifications When the Mailer has more Notifications to Process
(Doc ID 1392647.1)
Last updated on JULY 02, 2019
Applies to:Oracle Workflow - Version 18.104.22.168 to 12.2.7 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Customer is running EBS 11.5.10 + ATG Rup 7
Notifications are processed very slow on Fridays when the notification volume increases. Notifications are dequeued from WF_NOTIFICATION_OUT queue 2 or 3 hours after they were created.
The following actions were already taken but didn't help to improve performance:
1. wfntfqup.sql was already ran to re-created WF_NOTIFICATION_OUT manually
2. outbound thread was changed to 2
3. a new mailer was created
4. performed a coalesce on AQ IOTs and indexes for WF_NOTIFICATION_OUT queue
5. all the messages in PROCESSED status were purged
More time cards are generated on Fridays
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document