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

Last updated on JANUARY 17, 2017

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

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