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 ,
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-lReceived on Thu Sep 30 2010 - 04:57:45 CDT