| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rows Locked
Most of the time you can find out which row the user is waiting on
the row_Wait_row# will tell you what row it is waiting on and
row_wait_block# will tell you what block it is waiting and row_wait_file#
will tell you which file it is waiting for
all the above information u can get from v$session,
The user who is waiting for a lock_wait in the v$session will be having this
information.
use the dbms_rowid package which will tell you which table and which rowid
this is waiting on
get the rowid and you will find out which row it is waiting on
the following query will tell u which row a user is waiting on
you will have to login as sys to run this query.
you will get the table name along with the select statement and the table
name
this query can be run when the there is a lock issue
select INDX SID,KSUSESER SERIAL,KSUUDLNA USERNAME,KSUSEUNM OSUSER,
KSUSEMNM MACHINE,'select * from '||o.nametable_which_is_locked,' where
rowid=
'''||DBMS_ROWID.rowid_CREATE(1,to_number(o.DATAOBJ#),to_number(s.KSUSEFIL),
to_number(s.KSUSEBLK),to_number(s.KSUSESLT))||''';' "ROWID_LOCKED" from
x$ksuse s,obj$ o
where bitand(ksspaflg,1)!=0 and bitand(ksuseflg,1)!=0
and decode(s.ksqpswat,hextoraw('00'),null,ksqpswat) is not null
and o.obj#=s.ksuseobj
-----Original Message-----
Sent: Friday, February 15, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L
Yes. Trial and error method.
-----Original Message-----
Sent: Thursday, February 14, 2002 10:18 PM
To: Multiple recipients of list ORACLE-L
Is there a way to find out what rows are being locked ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alroy Mascranghe
INET: alroy_at_informatics.lk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 15 2002 - 13:24:35 CST
 |
 |