Q

I/O requirements for Oracle 11i implementation

We need to give our storage team the I/O requirements of an Oracle 11i implementation. What's the best way to obtain this information?

We need to give our storage team the I/O requirements of an Oracle 11i implementation. However, we are struggling to give an indication on whether we need 6K I/Os or 8K I/Os for a 1.6TB database with 1,200 concurrent users. What's the best way to obtain this information? And do our figures sound way off?

The first place to look at is your database configuration. Your database must be configured with a default database block size. The database block size is the smallest unit of I/O. The db block size can be 2K, 4K, 8K, 16K (and 32K on some platforms). Notice that 6K is not present in the list. Therefore, if you are considering 6K or 8K, I would strike 6K from the list automatically. When reading an entire table, the database will read...

multiple blocks at the same time. The number of blocks requested at the same time is defined by the DB_FILE_MULTIBLOCK_READ_COUNT parameter. This parameter is normally set to eight and should only be changed if you have a very good reason to do so.

If you have not created the database yet, then many people are going with an 8K block size for their databases.

This was first published in December 2006

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close