Re: Deadlock and ORA-0600 ocurred yesterday
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 26 Mar 2018 03:13:25 +0300
Message-ID: <CAOVevU79kiUjtAT2t8qZ093UO50a7F2BPi6RSTjo0-C1z1N+mg_at_mail.gmail.com>
Date: Mon, 26 Mar 2018 03:13:25 +0300
Message-ID: <CAOVevU79kiUjtAT2t8qZ093UO50a7F2BPi6RSTjo0-C1z1N+mg_at_mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 26 2018 - 02:13:25 CEST