BPEL Does a Full Table Scan of Tables dlv_subscription, document_dlv_msg_ref, and dlv_message

(Doc ID 832194.1)

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.

Symptoms

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.

Cause

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