Re: TX Enqueues - mode 4
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 7 Apr 2004 09:40:16 -0400
On 04/07/2004 09:01:48 AM, "Fedock, John (KAM.RHQ)" wrote:
> I know I have TX enqueues, with a mode = 4. From all my research, I bet it
> is ITL related.
Transaction enqueues with LMODE=4? In my reference document, LMODE=4
is "shared", while TX enqueues are always with mode 6 like here:
QL> select * from v$lock where sid=28;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST
-------- -------- ---------- -- ---------- ---------- ---------- ----------
CTIME BLOCK
---------- ----------
734B89C0 734B8ACC 28 TX 196645 100864 6 0
62 0
7345BFA8 7345BFBC 28 TM 40371 0 3 0
62 0
Here, I have a locked row. TX lock (row lock) is mode 6 (eexclusive) and DDL
lock (TM)
is mode 3 (Shared, row-exclusive). I don't see how can you have 4 in the LMODE
field
and TX in the Type field.
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
