In looking for information on an entirely unrelated Oracle issue, I came across
the following statement in the Oracle8i Administrator's Guide
Release 2 (8.1.6) for Windows NT, Chapter 1, "Oracle8i Differences between
Windows NT and UNIX"
The Oracle block size is 8K. The maximum number of blocks per data file is 4
million. The maximum number of data files per database depends on block size.
Hmm. "The Oracle block size _IS_ 8K. " (emphasis mine). Unless this was
written by someone who argues over what the meaning of "is" is, this would
indicated to me that the Oracle block size in NT is a fixed value, rendering the
init parameter db_block_size useless. Based on earlier readings (much, MUCH
earlier, when we were charged with bringing up our first Oracle db without even
knowing how to spell Oracle) we have that parm set to 4096 in all of our
Hmm. Then, after asserting that the block size *is* 8k, it goes on to say "The
. . . number . . . depends on block size.", implying that block size is *not* a
I guess it really does matter what the meaning of "is" is . . . .