Full Table Access on DLV_MESSAEGE Undeploying Composite
(Doc ID 2545934.1)
Last updated on MAY 15, 2023
Applies to:
Oracle SOA Suite - Version 12.2.1.3.0 and laterInformation 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
- 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|
--------------------------------------------------------------------------------------------
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 |