Re: ORA-600 Deadlock Issues
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: Egor Starostin <egorst@xxxxxxxxx>
- Date: Sat, 25 Jun 2005 16:12:56 +0000
On 06/25/2005 03:04:25 AM, Egor Starostin wrote:
> Are you sure that your first session doesn't receive ORA-60?
> Probably, you just don't look in first session output.
> I reproduced you case and ORA-60 was generated (which is expected).
>
> Note that hanganalyze in your case shows lock, not a deadlock.
> Deadlocks are printed in 'Cycles' section of hanganalyze trace file.
> Sessions from 'Open Cahins' section are just locks.
That is correct, my first session did receive ora-0060 but I wasn't able to
type fast enough. Yes, when I come to think of it, oracle will break the
chain as soon as it discovers it. Hanganalyze will not have time enough
to catch it.
--
Mladen Gogala
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
