BPEL Does a Full Table Scan of Tables dlv_subscription, document_dlv_msg_ref, and dlv_message
Last updated on NOVEMBER 27, 2017
Applies to:Oracle(R) BPEL Process Manager - Version 10.1.3.3.1 to 10.1.3.4 [Release AS10gR3]
Information in this document applies to any platform.
Using BPEL version 10.1.3.4 you find that BPEL is doing a full table scan on tables orabpel.dlv_subscription, orabpel.dlv_message, and orabpel.document_dlv_msg_ref
Due to this issue, users experience poor BPEL performance.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms