Geography Name Referencing Program Poor Performance (Doc ID 1980932.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Geography Hierarchy

Geography Name Referencing Program performance issues

Run the Geography Name Referencing Program with 20 workers in PROD and it is running slow.

This is the first time running the program in production.

The following profiles are set to:

HZ: Batch Size for committing records in Geography Name Referencing process - 1000
HZ: Number of workers for a given Geography Name Referencing request - 20

The GNR program is run only for US addresses with the following parameters:

Processing for Table : HZ_LOCATIONS
Run Type : ALL
Parameters: Country Code :US

EXPECTED BEHAVIOR
-----------------------
Expect the Geography Name Referencing program with 20 workers to complete in less than 3 hours.

Changes

Upgraded from 11i to R12. 

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