07-21-2017 9:47 AM
Dear Experts,
we are facing a performance and locking problem on our IS-Retail system and more specific when we are running WA08 to create subsequent documents through Allocation Tables.
In many cases when two ore more users execute this transaction we are facing locking problem - ENQUEUE Excl(Cumulative) AUKO 200$$$$$$$$$$ -
We found that there is the index FR2 on table FRET which is not activated in Database and we also show that the locking is last so much time exactly at the point of select on this table.
Does anyone faced this situation in the past ?
Is it safe to activate this index?
Thank you in advance.
07-21-2017 3:14 PM
07-24-2017 7:26 AM
Hello Francisco,
thank you for your answer. We already did the same regarding background processing. How can we do the parallel process?
Best Regards.
07-24-2017 8:28 AM
07-24-2017 9:38 AM
Hi George,
You can also look at activating the index as this will improve performance while querying the table.
Please do this off business hours.
Regards,
Prithviraj.