Salesprocess Batch Taking Long Time To Process POSU Files
(Doc ID 2762358.1)
Last updated on MARCH 31, 2021
Applies to:Oracle Retail Sales Audit - Version 16.0.1 and later
Information in this document applies to any platform.
Performance issue while processing the 5 POSU files for 5 different stores.
The job took 10 minutes to process 5 POSU files for 5 different stores , each file was linked to one thread.
Expected time was less than minute to process these 5 POSU files.
Steps to recreate:
- Run salesprocess batch with some POSU files.
- When checked logs ,observed that batch fails with the above error .
PGA memory is increased to 20GB.
- Validate that the batch is still failing with the 'ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT' error.
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