Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Odd statement in docs regarding block size
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"
<quote>
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.
</quote>
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 databases.
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 fixed value.
I guess it really does matter what the meaning of "is" is . . . .
Comments? Received on Fri Apr 05 2002 - 10:37:49 CST