Oracle Dead Locks

If dead lock happened for 2 applications at a time in a banking sector..how to resolve this issues without forcing any one of the application ..we should not have to stop the transaction...

karthikdb
Profile Answers by karthikdb Questions by karthikdb
May 20th, 2011
7
5485

Questions by karthikdb

Database Administration

Answer

Showing Answers 1 - 7 of 7 Answers

gyanudba
Profile Answers by gyanudba Questions by gyanudba

Jul 22nd, 2011

if dead lock occurs then find blocked session's sid and serial# from sql > select * from dba_blockers;
and kill that session with the help of > alter system kill session ' sid,serial#';

dharma

Aug 23rd, 2011

Dead Locks can be resolved by rollback statement.

Dharma Kotha
Profile Answers by Dharma Kotha

Oct 10th, 2011

A deadlock occurs when data was locked simultaneously by two sessions(users) and waiting for data, this can be resolved by rollback statement.