Re: Log Writer Freeze up - Deadlock ???

Dave Young wrote:
> I think it is a deadlock as any select on v$lock, or dba_transaction will hang
> yet you can select from v$session, user tables etc. Any suggestions would be
> apprecaited.

  If a deadlock occurs, a log will be written to logfile. Moreover, Oracle can resolve deadlock by rollback automatically. So, it will not be deadlock. On the other hand, there will be some resource problems (need further investigation) For instance, the audit trail is full.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841