ORA-2049

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Thu, 30 Sep 2010 11:57:45 +0200
Message-ID: <23A10476656B6540AA0077D8131FC80501A0C8C6_at_MSXVS03.trivadis.com>



Hallo ,

I have following lock problem.

JDBC session hangs with 'select for update' on the local table with ' enq: TX - row lock contention'. After 1 minute (distributed_lock_timeout) session gets ORA-2049 error

But

  • there is no blocking session , no other lock on the table
  • there are no database links in the DB (10.2.0.4)

There are only locks held by this session (including one DX lock)

 Username       Sid Term         Table Name                     COMMAND              Lock Held        Lock Requested   ID1 - ID2      Lock Type
---------- -------- ------------ ------------------------------ -------------------- ---------------- ---------------- -------------- ---------------------------------------
P8OSDBA         629 unknown      SYS.I_SUPEROBJ1                SELECT               Exclusive        NONE             66-0           DX - Distributed transaction entry lock                                                                                                                             
                                 P8OSDBA.GENERIC                SELECT               Row Exclusive    NONE             78474-0        TM - DML enqueue lock
                                 None                           SELECT               NONE             Exclusive        720930-37386   TX - Transaction enqueue lock



It is possible, that application defines some global transaction with DBMS_XA ? I tried to check during these 60 seconds other 7 DBs for locks,blocking_sessions, pending_session but couldnt find anything.

Has anybody some idea ?
Best Regards,
Petr

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 30 2010 - 04:57:45 CDT

Original text of this message