My Oracle Support Banner

Performance Problems with Notifications When the Mailer has more Notifications to Process (Doc ID 1392647.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle Workflow - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.