Lock in a Row [message #323154] |
Tue, 27 May 2008 08:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #323315 is a reply to message #323186] |
Wed, 28 May 2008 03:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|