Hello,
Brief description of our problem:
our company recently migrated from IFS9 (Oracle 12) to IFS Cloud (Oracle 19c). Both databases run on Oracle RAC. IFS9 worked well with Oracle RAC, but IFS Cloud can only function properly on one Oracle RAC instance. When we run the application on two nodes, we start receiving errors like: ORA-20113: JtTaskTransaction.FND_LOCKED: Update could not be fetched because the work task transaction record is currently locked. Retry the operation.
JtTaskTransaction - is one of several tasks, provided only as an example.
Our DBA analyzed the database logs and found that there are no RAC waits at the top, but a lot of TX row lock contention, waits event in Oracle databases that occurs when multiple sessions attempt to modify the same row(s) simultaneously.
Have you encountered similar problem in your practice? If so, could you please share some advice on how we can solve it or what we can try to find a solution? Currently we have service update 24.2.1.
Thank you in advance for your help!