Re: Deadlock and ORA-0600 ocurred yesterday

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: "Mark W. Farnham" <mwf@xxxxxxxx>
  • Date: Mon, 26 Mar 2018 03:13:25 +0300

As far as I remember standard deadlock detection interval for TM/TX locks
within single instance is 3 seconds, and 10 seconds in RAC since 11g (60sec
on <11g, but we can reduce it using_lm_dd_interval parameter)

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2018