Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find USER who locked my row ...

RE: How to find USER who locked my row ...

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Fri, 02 Feb 2001 09:17:07 -0800
Message-ID: <F001.002A92E1.20010202091619@fatcity.com>

Steve,

Unfortunately, I can't take out NOWAIT as it is part of the application design. They don't want the query to hang for some other user to unlock the record. There are plenty of users accessing the same table and the same row at the same time. We want the query to return with ORA-54, but at the same time we would like to know the the user/user details who locked the record of the table. This is part of the requirement of this application here.

Is there a way to find the details that we need? Please let me know if there is any solution.

Thanks ... Babu

-----Original Message-----
Sent: Thursday, February 01, 2001 6:51 PM To: Multiple recipients of list ORACLE-L

Hi Babu,

Take out the NOWAIT temporarily so that the session will wait, and then look in
V$LOCK to see which TX lock you are waiting for and who is holding it.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-----Original Message-----
Sent: Friday, 2 February 2001 9:50
To: Multiple recipients of list ORACLE-L

Dear list,

I am simulating an error generated by an application.

select * from XXX where fdoc_nbr = '12345' for update nowait;

It returns with error:
ORA-00054 Resource busy acquire with nowait specified.

I need to findout who(SID,SERIAL#,USERNAME) locked the same ROW (not table). There are many users who are locking different rows of the same table at the same time. I need to find the one who locked my row.

I would appreciate if someone could help me with this.

TIA,
-- Babu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Janardhana Babu
  INET: jbdonga_at_ucdavis.edu
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 02 2001 - 11:17:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US