RE: LOCK!!!

From: Arun Chakrapani <ArunC_at_1800FLOWERS.com>
Date: Thu, 31 Jan 2002 13:00:55 -0800
Message-ID: <F001.004029CA.20020131124528@fatcity.com>

Why dont u check it out from v$session_wait
>From what u have show below there is not locking issue
Check the v$session_wait,you should defnetly see something out there It is better always to come from v$session_Wait If you see any issues there then u got a probs

-----Original Message-----
Sent: Thursday, January 31, 2002 3:13 PM To: Multiple recipients of list ORACLE-L

Hi, guys,
Trying to figure out what my best option is. Some users are unable to access the system. Previously I had a trace file with " Deadlock detected ", but that session was killed.
SELECT * FROM V$LOCK WHERE block<>0 or lmode=6 /

ADDR           KADDR           SID  TY        ID1        ID2      LMODE
REQUEST      CTIME      BLOCK
--------       --------  ---------  --  ---------  ---------  ---------
---------  ---------  ---------
037DFE74  037DFE84          3     RT          1          0
6                     0    1464073          0

Any quick advice is appreciated.
Best,
Sergey

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babich , Sergey
  INET: SBabich_at_handexmail.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: Arun Chakrapani
  INET: ArunC_at_1800FLOWERS.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).

Received on Thu Jan 31 2002 - 15:00:55 CST