My Oracle Support Banner

Number Of Jobs Scheduled During Online Purge Is Not Equal To The Parallelism Specified (Doc ID 2219513.1)

Last updated on APRIL 03, 2023

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to 7.2.4 [Release 7.2]
Information in this document applies to any platform.

Goal

On : 7.2.0 version, Database

Number of jobs scheduled during online purge is not equal to the parallelism specified

In a database RAC containing two nodes and below is environment configuration.

Oracle OSM 7.2.0.11.2
DB Version 11.2.0.4
Oracle WebLogic 10.3.5

DB Patches installed: patch 18966843 exists along with 18238463 and 19769489 (Database Patch Set Update : 11.2.0.4.5).

Scenario :
Customer ran online purge with parallelism 24
=> The number of jobs running the delete statements on both the nodes was not equal to the parallelism.





 

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.