The Oracle (tm) Users' Co-Operative FAQ

What is a good block size for my database ?

Author's name: Jonathan Lewis

Author's Email:

Date written: 10th Jan 2002

Oracle version(s): n/a

Oracle allows block sizes from 2K to 32K with a maximum dependent on the specific platform. How should you choose the most appropriate block size for your database ?

Back to index of questions

This question is addressed by the following documents:



Suggested by

Referee's comments

Howard Rogers

What's a good block size ?

Jonathan Lewis

One of several “discussion documents” on the Dizwell website that take the time and space to examine Oracle features properly.






Further reading:

Back to top

Back to index of questions