Performance Issue With BOM_RTG_PUB.PROCESS_RTG When Add Item to Delete Group
Last updated on MARCH 17, 2016
Applies to:Oracle Bills of Material - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Bills of Material - Version 184.108.40.206 to 220.127.116.11 [Release 11.5]
Information in this document applies to any platform.
When adding 50000 items to BOM delete group using BOM_RTG_PUB.PROCESS_RTG API, it takes 3 hours.
From AWR report Following SQL take much time.
Improve the performance to add items to BOM delete group using BOM_RTG_PUB.PROCESS_RTG API
Steps to Reproduce
- Run BOM_RTG_PUB.PROCESS_RTG API
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms