Re: Tuning deadlocks

From: Jared Still <jkstill@xxxxxxxxx>
To: peterdixon001@xxxxxxxxxxx
Date: Fri, 16 Sep 2005 19:07:30 +0100

Hi Peter,

Perhaps you could let us know what the actual error number is?

There are many kinds of deadlocks, the most common one is 
probably ORA-60,  which is an application problem.

Others such as ORA-4020, may not be an app problem.


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.


On 9/16/05, Peter Dixon <peterdixon001@xxxxxxxxxxx> wrote:
> I have two live databases running the same application, one of the databases
> has deadlocks which the database seems to cope with quicker than the same
> application running on the other database. It version 8.1.7.4 and I have
> checked the init.ora including hidden parameters like LM_DD_INTERVAL
> are there any other parameters which might resolve this problem?
>
--
http://www.freelists.org/webpage/oracle-l

References:

Tuning deadlocks
From: Peter Dixon

Re: Tuning deadlocks

Other related posts: