Undeploying BPEL Composites Is Taking Too Long (Doc ID 2137251.1)

Last updated on MAY 13, 2016

Applies to:

Oracle Metadata Services - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Undeploying SOA composite in 12.1.3.0.0 is taking too long.

As a part of troubleshooting the issue and analyzing the AWR reports it was found the following type queries were the cause of the performance issues.

DELETE /*+ LEADING(MDS_PATHS) */ FROM MDS_ATTRIBUTES
WHERE EXISTS (SELECT PATH_CONTENTID FROM MDS_PATHS WHERE PATH_DOCID=:1
AND PATH_CONTENTID = ATT_CONTENTID AND PATH_PARTITION_ID = ATT_PARTITION_ID AND PATH_PARTITION_ID=:2 )

 

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')

 

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