Re: DBWR average scan depth

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 31 Aug 2000 03:10:24 -0700 (PDT)
Message-Id: <10605.115945@fatcity.com>

Hi !

In earlier versions of Oracle (read: Oracle 8 and below) the DBWR average scan depth is a function of Oracle.

In Oracle 8.1 the DBWR algorithms are changed (and the buffer cache meanagements also with the introduction of 'touch count' and 'mid point insertion' instead of typical LRU..I.e The LRU is no more used to manage the buffer cache).

So setting db_files to a higher number infaltes the DBWR avg scan depth in oracle 8.

Warm Regards,
K Gopalakrishnan
Bangalore, INDIA

• "Libal, Ivo" <ivo.libal_at_knapp-systems.com> wrote:
  > Hello All
  > what is the relationship between db_files and DBWR
  > average scan depth?
  > Thank you
  > Ivo Libal
  >
  > --
  > Author: Libal, Ivo
  > INET: ivo.libal_at_knapp-systems.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! Received on Thu Aug 31 2000 - 05:10:24 CDT