Re: CHECKPOINTS QUESTION
From: Geoff Ingram <lsgvi02_at_chsrh1.agw.bt.co.uk>
Date: 1996/10/08
Message-ID: <325A2B30.357_at_chsrh1.agw.bt.co.uk>#1/1
All my own personal opinions Received on Tue Oct 08 1996 - 00:00:00 CEST
Date: 1996/10/08
Message-ID: <325A2B30.357_at_chsrh1.agw.bt.co.uk>#1/1
Alexander Bardos wrote:
>
=> What happens when an instance runs out of db buffer cache blocks (
> unmodified ) and there are only dirty blocks available?
[rest deleted]
DBWR also flushes dirty blocks under conditions other than a checkpoint: when a DBWR timeout occurs (every 3 secs) when dirty buffer length reaches a threshold to free up some buffers on the LRU list
see Oracle7 Server Concepts
Geoff Ingram
All my own personal opinions Received on Tue Oct 08 1996 - 00:00:00 CEST