My Oracle Support Banner

SOA Purge Hangs on PDB 19c Of SOA (Doc ID 2854257.1)

Last updated on MARCH 10, 2022

Applies to:

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

Goal

The Oracle SOA BPL product has some problems during the following delete statement execution:

**********************************************************************************************************
DELETE FROM MEDIATOR_PAYLOAD WHERE OWNER_ID NOT IN (SELECT UNIQUE DUMMY1 FROM MEDIATOR_DEFERRED_MESSAGE UNION SELECT UNIQUE ID FROM MEDIATOR_RESEQUENCER_MESSAGE);

SQL_ID PLAN_HASH_VALUE
------------- ---------------
8kmgw4h4bjvdx 207496391
**********************************************************************************************************

The statement is executed by SOA product purge procedure.

The error occurs on PDB 19c
 

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.