Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!y42g2000hsy.googlegroups.com!not-for-mail From: carab1n3r Newsgroups: comp.databases.oracle.server Subject: deadlocks and redologs interaction Date: Tue, 11 Sep 2007 17:20:31 -0700 Organization: http://groups.google.com Lines: 25 Message-ID: <1189556431.717705.65440@y42g2000hsy.googlegroups.com> NNTP-Posting-Host: 64.18.7.193 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1189556431 19495 127.0.0.1 (12 Sep 2007 00:20:31 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 12 Sep 2007 00:20:31 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: y42g2000hsy.googlegroups.com; posting-host=64.18.7.193; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Xref: usenetserver.com comp.databases.oracle.server:434821 X-Received-Date: Tue, 11 Sep 2007 20:20:32 EDT (text.usenetserver.com) I'm still relatively green as a DBA, so excuse the possibly simple question... We have a DB that is seeing a lot of deadlocks, occasionally hundreds at a time. Yes, typically this is an external-application/development problem. However, I'm trying to determine and/or explain what impact lots-o- deadlocks has on redolog, particularly the switching. The reason I mention it is that during these "deadlock storms", we occasionally run out of redologs to switch to. The drumbeat I'm hearing is to "just add more redolog groups!!!" since that's easy to do, but we're only running into this redolog-switching problem during the deadlock storms, and my gut is that this is just a bandaid and will eventually not resolve the problem as deadlock rates continue to increase. So can someone explain to me (in such a way that I can explain it to others), when we have lots of deadlocks, what impact does that have on redologs? Thanks a lot in advance for the advice.