Skip to Content
0
Former Member
Feb 19, 2009 at 05:20 PM

Oracle Lock wait

667 Views

Hello,

In BW system we found that there is oracle lock wait situation for an object

-


Object Status SID oracle sha PID Machine Time

----


*/BIC/EIBS_SWIH1 HOLD 1761 18884 11572 er3as132 186812*

----


However when we tried to search the PID 11572, in SM66, SM50 and at OS level, we are unable to find the process ID anywhere.

We searched the process ID in ST04 -->Oracle Sessions, there we found the SQL statement which is being executed.

Can any one suggest how the process can be searched and how to release the DB01 oracle lock entry ?

Thanks & Regards

Girish