OWB 11g Sessions are blocking Other OWB Sessions When Executing Many Mappings or Process Flows in Parallel (Doc ID 1562861.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

When running many OWB 11g mappings/process flows in parallel, lots of blocking session are signaled by Grid Control. 
e.g.: 

The blocking session messages disappear after some time.

Changes

The issue might occur when executing OWB tasks after an upgrade of Oracle 10g to Oracle 11g.  

Cause

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