10g - controlfile block size is 16 KB

Something that has changed - just a tidbit, nothing major. I know that the controlfile block size used to be 8 KB in 8.1.7. I didn't really pay much attention to it in 9.2. Here in 10.1, the controlfile block size is now 16 KB (win32).

For you folks at home that like to align your filesystem block size with your file block size, here's one more reason to have a filesystem with a 16 KB block size in addition to the 4 KB block size for the OS pagefile (win32) and a 512 byte block size for the online redo logs and an 8 KB block size for the datafiles (assuming the db_block_size = 8KB).

(going to try to use a 16 KB block size tablespace for some IOTs to see if I can knock a blevel=3 down to a blevel=2)

tidbit from the alert log during db create:

Sat Oct 23 17:08:29 2004
Controlfile created with 252 blocks of size 16384 bytes

Yes, none of this matters if ASM is chosen - except for that minor issue of having to setup the +ASM database files on storage prior to being "ASM-enabled".

and I'm not quite there yet.

Paul

PS - Alan - you've now got your 10g playground.

--
http://www.freelists.org/webpage/oracle-l