Hi Team,
We have an urgent requirement to push ~13K Task details to Project . We tried creating a process through which we are processing all the records using batch.
Per batch we tried to process 100 records (Creating Project XOG formatting with 100 Tasks at a time and hit XOG),however this led us to DB performance issue - Memory consumption reaching upto 95% - PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
The second scenario was to decrease per batch size upto 50 records - Which is too slow now (It could XOG in ~4k records in ~1 hour ).
Could you please help us on any better approach to XOG all the Task with a better performance.
Please find the process in attachment.
Regards,
Abhinav Panigrahi