My Oracle Support Banner

SOA 11g - sca_undeployComposite Command Executes an innefficient DELETE Statement in SOA Database (Doc ID 1942976.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

SOA 11.1.1.7 is using the below inefficient delete statement when undeploying a very large BPEL composite via the sca_undeployComposite command.

DELETE
FROM MDS_PATHS
WHERE PATH_PARTITION_ID = :1
AND PATH_TYPE           = 'DOCUMENT'
AND PATH_DOCID         IN
 (SELECT A.PATH_DOCID
 FROM MDS_PATHS A,
   MDS_PATHS B
 WHERE A.PATH_PARTITION_ID = B.PATH_PARTITION_ID
 AND A.PATH_PARTITION_ID   = :2
 AND (A.PATH_HIGH_CN       = A.PATH_LOW_CN
 AND A.PATH_VERSION        < 0 )
 AND (B.PATH_HIGH_CN       = B.PATH_LOW_CN
 AND B.PATH_VERSION        < 0)
 AND B.PATH_HIGH_CN        > A.PATH_HIGH_CN
 AND A.PATH_TYPE           = B.PATH_TYPE
 AND A.PATH_DOC_ELEM_NSURI = B.PATH_DOC_ELEM_NSURI
 AND A.PATH_DOC_ELEM_NAME  = B.PATH_DOC_ELEM_NAME
 AND A.PATH_TYPE           = 'DOCUMENT'
 )



Solution

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
Goal
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.