Undeploying BPEL Composites Is Taking Too Long
Last updated on MAY 13, 2016
Applies to:Oracle Metadata Services - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 12c]
Information in this document applies to any platform.
Undeploying SOA composite in 126.96.36.199.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.
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 )
( 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')
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