Home » RDBMS Server » Server Administration » session get locked
session get locked [message #270329] Wed, 26 September 2007 10:01 Go to next message
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 Go to previous message
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
Previous Topic: Can't change NLS_LANG in Oracle XE
Next Topic: no listner
Goto Forum:
  


Current Time: Wed Dec 04 19:55:14 CST 2024