I have SAP R3 / ECC6 on AIX 5.3 System. Database Oracle 10g.
I would like you to explain me if there is a way to solve this problem about locks.
Let me explain:
We have several jobs launched all nights (specifics programs) and some of them access to same tables (MBEW for example).
When I launch a single job in development system, it takes 2 hours. When I Launch this same job in Production, it takes more than
10 hours! That's why I think this job is blocked by locks from others jobs.
How can I verify that locks are the problems?
Could I configure locks not to lock other users when accessing the table?
Many thanks for your help.