My Oracle Support Banner

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 11.5.10.2 to 12.2.7 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

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

Changes

More time cards are generated on Fridays

Cause

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
Symptoms
Changes
Cause
Solution
References


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