Oracle Lock wait

[Former Member]

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

[stefan_koehler · Accepted solution]

Hello Girish,

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

That's the right way. You can also search for the session id (1761), it should be easier.

> how to release the DB01 oracle lock entry ?

Just do this

shell> sqlplus / as sysdba
SQL> SELECT SID, SERIAL# FROM V$SESSION WHERE SID = 1761;
SQL> ALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>' IMMEDIATE;

It can take a moment until the locks are released.

Regards

Stefan