Re: finding solution 4 this Special DeadLock

On Sun, 10 Feb 2008 02:04:02 -0800, meysam.khayatan wrote:

> Dear friends

This is an annoying start. I am very selective about my friends and I cannot recollect ever becoming your friend.

> i have a problem in DeadLock
> in udump alert log file i have a deadlock that in trace file described
> as below:
> =============================================================== ***
> 2008-02-06 09:00:06.223
> *** SESSION ID:(32.18099) 2008-02-06 09:00:06.219 DEADLOCK DETECTED
> Current SQL statement for this session: LOCK TABLE PER_ANALYSIS_CRITERIA
> IN EXCLUSIVE MODE The following deadlock is not an ORACLE error. It is a

It is an application error. Fix the @#$%! application. Using exclusive table locks in an application that uses Oracle RDBMS is about the most idiotic thing one can make. Piece on Earth!

-- 
http://mgogala.freehostia.com