Re: Help with Locking Issue

Jay
 It looks like the application is locking the FIXED_ASSET_ACTIV exclusive. Is the application written in Visual Basic and they are issuing a SELECT FOR UPDATE clause?
The developers here loved the clause even if it wasn't the table they were updating. It sounds reasonable....I'm doing an update so there fore the data selected to get the row from a different table updated must be "SELECT FOR UPDATE".... NOT! . It took a while but they stopped that practice and things run smoother now.
Ron
ROr mª¿ªm

>>> jhostetter_at_decommunications.com 04/18/02 12:58PM >>>
  I have been spending most of my morning trying to resolve a locking issue. I think I could me missing the forest for the trees. This is what happens: a user kicks off two identical jobs from two different PCs. Each of these jobs is doing the same thing, but against different rows of data (they are processing "work orders" in our system, but each job is processing a different work order).   One session will wait until the other session completes. I am trying to figure out what they are waiting on. At first I assumed a locked record, but I don't think that is the case. I did quite a bit of research on MetaLink. I even rebuilt the table in case INITRANS and PCTFREE might be too small, but that didn't seem to help either. Here is the output from the query in note 1020047.6.

Sess          Op Sys              OBJ NAME or
 ID  USERNAME User ID    TERMINAL TRANS_ID          TY Lock Mode   Req

---- -------- ---------- -------- ----------------- -- -----------
-----------
  12 KEN468   ken468     KEN468-1 FIXED_ASSET_ACTIV TM Row Excl
  12 KEN468   ken468     KEN468-1 Trans-196694      TX Exclusive
  14 KEN468   Batch      BATCH    FIXED_ASSET_ACTIV TM Row Excl
  14 KEN468   Batch      BATCH    Trans-196694      TX --Waiting--
Share
  14 KEN468   Batch      BATCH    Trans-65597       TX Exclusive

So session 14 is waiting for a share lock. Session 12 has an exclusive lock that is blocking session 14. How do I find out what session 12 has locked that is needed by session 14?

Thanks,
Jay

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.com 

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: Ron Rogers
  INET: RROGERS_at_galottery.org

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