My Oracle Support Banner

Full Table Access on DLV_MESSAEGE Undeploying Composite (Doc ID 2545934.1)

Last updated on JANUARY 14, 2020

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
You experience high load on the database when attempting to undeploy a composite using any one of the following methods:

- via EM Console
- executing WLST command sca_undeployComposite()
- using Java MBean:
oracle.soa.config:Application=soa-infra,j2eeType=CompositeLifecycleConfig,name
=soa-infra, removeCompositeForLabel



The following query executes in the SOAINFRA schema using TABLE ACCESS FULL':

UPDATE DLV_MESSAGE SET STATE = :1 WHERE (((((((COMPONENT_NAME = :2 ) AND (COMPOSITE_NAME = :3 )) AND (COMPOSITE_LABEL = :4 )) AND (DOMAIN_NAME = :5 )) AND (COMPOSITE_REVISION = :6 )) AND(STATE IN (:7 , :8 , :9 ))) AND (DLV_TYPE = :10 ))

Plan hash value: 68502318

--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time | Pstart| Pstop |
--------------------------------------------------------------------------------------------
| 0 | UPDATE STATEMENT | | | 4676K(100)| | | |
| 1 | UPDATE | DLV_MESSAGE | | | | | |
| 2 | PARTITION RANGE ALL| | 1 | 4676K (1)| 00:03:03 | 1 |1048575|
| 3 | PARTITION HASH ALL| | 1 | 4676K (1)| 00:03:03 | 1 | 32 |
| 4 | TABLE ACCESS FULL| DLV_MESSAGE | 1 | 4676K (1)| 00:03:03 | 1 |1048575|
--------------------------------------------------------------------------------------------



EXPECTED BEHAVIOR
-----------------------
Undeploying composites should not impact database performance.



Cause

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
Symptoms
Cause
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.