Re: Someone remind me - SLOW LGWR - buffer flushes prevent new blocks being read in
From: William Muriithi <william.muriithi_at_gmail.com>
Date: Thu, 18 Oct 2012 15:32:41 -0400
Message-ID: <CAE9rU+6VtXGj=VP8ZveXSqi=s7ijeX9_bsmyucSjC=BKzF16kg_at_mail.gmail.com>
> 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?
>
You mean when log writer is slow and the database exhaust the three redo files and hang the database ?
> Chris
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
Date: Thu, 18 Oct 2012 15:32:41 -0400
Message-ID: <CAE9rU+6VtXGj=VP8ZveXSqi=s7ijeX9_bsmyucSjC=BKzF16kg_at_mail.gmail.com>
> 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?
>
You mean when log writer is slow and the database exhaust the three redo files and hang the database ?
> Chris
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 18 2012 - 21:32:41 CEST