session get locked [message #270329] |
Wed, 26 September 2007 10:01 |
ahamed_oradba
Messages: 1 Registered: September 2007
|
Junior Member |
|
|
session get locked
hi all, i execute the following view,
SQL> select * from dba_blockers;
HOLDING_SESSION
---------------
91
SQL> select * from dba_waiters;
WAITING_SESSION HOLDING_SESSION LOCK_TYPE
--------------- --------------- --------------------------
MODE_HELD
----------------------------------------
MODE_REQUESTED LOCK_ID1 LOCK_ID2
---------------------------------------- ---------- ----------
74 91 Transaction
Exclusive
Share 786447 2050835
so i killed the sid 74,
then i used dba_blockers and waiters it says no rows selected. later a while i can see the same sid and same things are waiting and holding.
so can any one help me on this.
regards
ahmed
|
|
|
Re: session get locked [message #270336 is a reply to message #270329] |
Wed, 26 September 2007 10:16 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
If you want you have to first read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).
Regards
Michel
|
|
|