Nidhi

• 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.

naveen5555

 Profile Answers by naveen5555 

• 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

prahlad_786

 Profile Answers by prahlad_786 

• 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.