Home » RDBMS Server » Server Administration » Lock in a Row
Lock in a Row [message #323154] Tue, 27 May 2008 08:22 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
Hi to all,

I am using oracle 10g release 2. We are using .net as the front end. When we run the application it remains hangs. When i used the below query to find which row is locked

==============================================================
select
do.object_name,row_wait_obj#,row_wait_file#,
row_wait_block#,row_wait_row#,dbms_rowid.rowid_create (1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#,ROW_WAIT_BLOCK#, ROW_WAIT_ROW#)

from v$session s,dba_objects do
where sid=209
and s.ROW_WAIT_OBJ# = do.OBJECT_ID
==============================================================


The output i got is

========================================================
OBJECT_NAME ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# DBMS_ROWID.ROWID_C
------------- -------------- --------------- ------------- ------------------
IDX_BSPC_BENCH_MOLD 9292 20 2031 0 AAACRMAAUAAAAfvAAA
=========================================================

object named IDX_BSPC_BENCH_MOLD is locked.

Can any one suggest a way to clear this lock.


Thanks in Advance,
Seenu
Re: Lock in a Row [message #323158 is a reply to message #323154] Tue, 27 May 2008 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
ALTER SYSTEM KILL SESSION.....
Re: Lock in a Row [message #323186 is a reply to message #323154] Tue, 27 May 2008 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Commit or rollback from the holding session.

Regards
Michel

[Updated on: Tue, 27 May 2008 10:51]

Report message to a moderator

Re: Lock in a Row [message #323315 is a reply to message #323186] Wed, 28 May 2008 03:09 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


The lock occured because of running front end ASP .net how can i give commit or rollback in the front end.


I have also used

alter system kill session.

That session is killed. But If we open another session the same problem exists.


Thanks,
Seenu
Re: Lock in a Row [message #323345 is a reply to message #323315] Wed, 28 May 2008 04:40 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix your application that it ends the transaction before living.

Regards
Michel
Previous Topic: Session Block
Next Topic: DB parameters
Goto Forum:
  


Current Time: Thu Dec 08 20:32:36 CST 2016

Total time taken to generate the page: 0.13415 seconds