My Oracle Support Banner

Geography Name Referencing Program Poor Performance (Doc ID 1980932.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


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

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


Upgraded from 11i to R12. 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.