Yes, the "write batch" size is no longer dependent on db_files from 8.1, so the
db_files setting has no impact on DBWn tuning.

Nothing much has changed about the updating of datafile headers during a thread
or global checkpoint, except that the CKPT process is now mandatory. I said that
the impact of the number of files here was small, because it is done in the
background by a non-performance critical process. So, the only impact that we
care about is that the extra disk head movement for these writes might extend
the services times of concurrent foreground I/O operations slightly. That's not
really something to worry about, I just mentioned it for completeness.


-----Original Message-----
Sent: Thursday, 31 August 2000 18:38


Re: http://www.ixora.com.au/q+a/0008/30150113.htm

About your statement...

"Up to 8.0 the number of data files had a potential
impact on DBWn performance, not that it could not be
managed with proper tuning"

In terms of DBWn performance, for me, it always been
keep the number of files down to keep checkpoint time
small, and keep db_files down to keep the write batch
down...

Has something changed from 8.x upwards that improves
upon/changes this strategy ?