Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In alert log there are a lot of "Transaction recovery: lock conflict caught and ignored" statements.

I've found some information, that this error is caused when there is an active dead transaction. For example, long running transaction was forcefully stopped and it did not managed to recover(caused by no free space in UNDO tablespace, or aborting database...)

When I query the following:

select b.name useg, b.inst# instid, b.status$ status, a.ktuxeusn
xid_usn, a.ktuxeslt xid_slot, a.ktuxesqn xid_seq, a.ktuxesiz undoblocks,
a.ktuxesta txstatus
from x$ktuxe a, undo$ b
where a.ktuxecfl like '%DEAD%'
and a.ktuxeusn = b.us#;

It returns 23 rows , so there are active dead transactions.

I tried to DUMP UNDO HEADER, dig in the trace files and find object ids that needed recovery. I found these objects and re-created them(was suggested in some blog) but still did not help.

Note: When there is a supplemental logging enabled , Oracle creates incident files and core dump files and writes mentioned error in alert log, which causes server space to be exhausted. If you turn the supplemental logging off, just alert log contains this error message and NO incident/core dump files are created, better variant, but still disturbing when entries are a lot.

share|improve this question
    
Is this message connected to same ORA- error number? –  ibre5041 Jan 10 at 13:44
    
@Ivan No ORA- , just "Transaction recovery: lock conflict caught and ignored" 132(92 sometimes 223) lines together –  kupa Jan 10 at 13:52
    
@Ivan As I remember when there was supplemental logging enabled it contained ORA- in front of it and incident files were being created. But after disabling it just that statement is repeated for many times. –  kupa Jan 10 at 13:54
    
What version? There are bugs relating to this –  FreshPhilOfSO Jan 10 at 15:35
    
@Phil The Oracle version is 11.2.0.1.0 –  kupa Jan 13 at 14:01
show 1 more comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.