What is mean live dead lock? How to prevent it.?

Questions by ashutoshtodkar05

Showing Answers 1 - 3 of 3 Answers


  • Feb 10th, 2007

When there r 2 or more process run at a time and want to same resource then if one process take resource and othere process want same resource then there will be dedlock occour.

  Was this answer useful?  Yes


  • Sep 22nd, 2007

A deadlock occurs when two or more users are waiting for data locked by each other(Not commited by user01).

To fix this, recreate the segment with higher INITTRANS and/or PCTFREE values. This will allow more space in the data blocks for Oracle to allocate more transaction entries (24 bytes at a time) when required

  Was this answer useful?  Yes


  • Jun 23rd, 2010

Whenever you have competing DML running against the same data, you run the risk of a deadlock.

Tune the application - Single-threading related updates and other application changes can often remove deadlocks. Re-scheduling batch update jobs to low-update times an also help.

Add INITRANS - In certain conditions, increasing INITRANS for the target tables and indexes(adding slots to the ITL) can relieve deadlocks.

Use smaller blocks with less data - Since the deadlock contention is at the block-level, consider moving these tables and indexes to a super-small blocksize (create a db2k_cache_size), and using a high PCTFREE to space-out the data over MORE blocks.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions