Quote Originally Posted by slimdave
Nope, the value should be the same as the system's maximum i/o size divided by the system tablespace block size.
I respectfully disagree.

This parameter greatly dependes upon the type of system you are setting up. If OLTP/DSS then a smaller number in the 4-16 is probably a very good choice.

But if its say a DW, then large number up to the maximim I/O size would be a better choice.

Also, your block size should be greater than or equal to the OS I/O size.

Regards,
Ken