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