We need to inform our storage team of the I/O requirements required to implement Oracle 11i. However, we are confused about choosing 6 k I/O or 8 k I/O. Our database size is 1.6 TB and there are about 1200 concurrent users. What is the best way to understand this information? Is our description outrageous?
Experts replied:
The first thing to see is your database configuration. Your database must be configured with the default database block size. The database block size is the smallest unit of I/O. The database block size can be 2 K, 4 K, 8 K, or 16 K (32 K for some platforms ). Note that 6 K is not in the list. Therefore, if you consider 6 K or 8 K, I will automatically remove 6 K from the list. When reading the entire table, the database reads multiple blocks at the same time. The number of blocks required at the same time is defined in the DB_FILE_MULTIBLOCK_READ_COUNT parameter. This parameter is usually 8, and this number is not modified unless you have a good reason.
If you have not created a database, many people will adopt an 8 K block size for their database.