Performance: Purge Obsolete Workflow Runtime Data ( FNDWFPR ) Concurrent Request is Slow
(Doc ID 985332.1)
Last updated on AUGUST 11, 2022
Applies to:
Oracle Workflow - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]Information in this document applies to any platform.
Symptoms
NOTE: The code fixes within this document have been consolidated in <Note 132254.1>. Please reference this document for the latest updates.
The Purge Obsolete Workflow Runtime Data ( FNDWFPR ) concurrent request takes long to complete. There are millions of records in workflow tables (wf_items ).
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 |
Cause |
Solution |
Workflow Information Center, Diagnostics, & Community |
References |