Fabrizio, Nice research on the more modern abilities of Windows/Disk.
My comment on wasting 25% of the IO had to due with the OS block size
being 4k or 8k and the Oracle block size being 6k. 2K of data the OS
reads is not passed to Oracle and is therefore wasted effort. My point
was that Bernhard should look to see what his setup was using for the
OS IO block size and match Oracle to it or at least make them even
multiples of each other.
Back in the days of mainframe 3380 disk drives 6k was a very efficient
block size for utilizing the full track of a disk.
Received on Mon Apr 11 2005 - 09:03:27 CDT
