Locking in R3

[Former Member]

Hi All,

I have a doubt , oracle by itself incorporates row level locking. Since SAP R3 runs on top of it the update queries should also incorporate row level locking.

I feel row level locking dont stay for long on a database after the record has been updated.

Then how can there be 8 thousand lock entries in a given point of time in a system. These locks do stay for more than 9 to 10hrs at times.

Kindly provide some links to understand this concept. These lock entries are not following row level locking?

Thanks,

Swadesh

[former_member235680 · Accepted solution]

hi Swadesh,

Have a look on links below, regarding lock Mechanism...

http://help.sap.com/saphelp_46c/helpdata/en/c2/2d7037ecc92a7ee10000009b38f8cf/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm

Thanks

A.Kumar

[Former Member · Accepted solution]

Hi Kumar,

Thanks for your reply.

Regards,

Swadesh

[AtulKumarJain]

Hi Swadesh,

Please check http://help.sap.com/saphelp_nw04/helpdata/en/fb/aad1811dd446659df0380264089b24/content.htm

http://scn.sap.com/thread/1510479

if still you have any qestion please feel free to ask.

BR

Aj

[Former Member]

Hi Atul,

Thanks for reply , that was helpful.

I will come back with my questions.

Regards,

Swadesh