Someone remind me - SLOW LGWR - buffer flushes prevent new blocks being read in
From: <Christopher.Taylor2_at_parallon.net>
Date: Thu, 18 Oct 2012 14:24:53 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88562E48CE1_at_NADCWPMSGCMS10.hca.corpad.net>
I was reading somewhere (and I can't put my hands on it now of course) where when LGWR is slow, that it backs stuff up bad enough that blocks can't get into the cache fast enough and will slow the whole database down (that's the gist of it I think). When LGWR is exceptionally slow/hung. Can someone point me in the right direction here?
Date: Thu, 18 Oct 2012 14:24:53 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E88562E48CE1_at_NADCWPMSGCMS10.hca.corpad.net>
I was reading somewhere (and I can't put my hands on it now of course) where when LGWR is slow, that it backs stuff up bad enough that blocks can't get into the cache fast enough and will slow the whole database down (that's the gist of it I think). When LGWR is exceptionally slow/hung. Can someone point me in the right direction here?
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 18 2012 - 21:24:53 CEST