Re: Tuning deadlocks

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 16 Sep 2005 19:07:30 +0100
Message-ID: <bf4638050916110741f80070@mail.gmail.com>

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_at_hotmail.com> 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

Received on Fri Sep 16 2005 - 13:37:24 CDT