lock of jobs (V$LOCK)

[Former Member]

Hi All,

Every time i execute a job there is a lock and in SM50 job appears with V$LOCK (same situation for every job).Note 126676 specifies solution for this but the note is only applicable till Oracle 9i but our DB is Oracle 10g.Let me know how to resolve this issue.

Thanks in advance for the help,

Raj

[Former Member · Accepted solution]

Hi,

Is this a SAP standard program or customer program ?

Mark

[Former Member · Accepted solution]

Hi Mark,

These are SAP programs (ex: SAPLSTD1) and SAP folks are doing some currency conversion.They are facing this issue during this conversion.Let me know how to proceed.

Thanks,

Raj

[Former Member · Accepted solution]

Hi,

when these locks are happening what do you see in transaction DB01 ?

Mark

[Former Member · Accepted solution]

Hi Mark,

When i am running transaction DB01 a msg window is popping up saying that NOT ORACLE VERSION 8/9 - PROGRAM ABORTED (Program RSORALCK).Let me know if you know some work around for this,

Thanks,

Raj

[Former Member · Accepted solution]

Hi implement this via SNOTE and try again....

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=965485

Can you paste in the contents of your init<SID.ora or Spfile hichever one you have decided to use.

Mark

[Former Member]

Hi Raj,

Check the following note.It may help you to investigate.

[Note 787533 - Bad performance/ system lockup due to enqueue waits|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=787533]

Thanks & Regards,

Nagendra