Skip to Content
0
Former Member
Nov 23, 2011 at 11:24 AM

Lock on a table

331 Views

Hi Everydoby.

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.

Regards