My Oracle Support Banner

OWB 11.2 Shows Poor Performance On Mapping Validation / Generation / Deployment (Doc ID 1303177.1)

Last updated on JANUARY 30, 2022

Applies to:

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

Symptoms

Poor performance of mapping Validation and Generation in the following setups:

1. OWB 11.2.0.1 + Cumulative <Patch 10270220>: 11.2.0.1 MEGA_PATCH V2 : (MERGE) PSE ON TOP OF 11.2.0.1 FOR BUGS

The performance issue does not occur in OWB 11.2.0.1 without the cumulative patch.



2. OWB 11.2.0.2 and later versions


when pressing CTRL-BREAK during the generation or validation process, the code hanging at this point:


The performance issue occurs when the Hostname of Source and Target Locations have an IP address.


Note that this issue also impacts deployment performance, since Validation and Generation are part of the deployment process.

 

 

Changes

1. Cumulative patch 10270220 applied on top of OWB 11.2.0.1

or

2. OWB upgraded to OWB 11.2.0.2 or later version.

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
Changes
Cause
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.