What is a good blocksize for my database ?

Author's name: Jonathan Lewis

Author's Email: Jonathan@jlcomp.demon.co.uk

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 ?

Author

Title/URL

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.