Re: Change DB_BLOCK size

If the initial extent size is not explicitly declared in the object or in the tablespace default storage, Oracle will use the default of 5 data blocks.

However, all of that is besides the point. There is a lot more to choosing the appropriate database data block size than the size of some small tables! The database data block size must be chosen based on a number of variables, like is it mostly OLTP or batch; what about the other tables -- are they very large or also small; what about the length of the rows in the tables -- if they are over 4k, creating a database block size of 4k will automatically cause chained rows. In other words, there are lots of things to consider before changing a database data block size. Since storage is one of the cheapest aspects of the hardware costs, the size of small tables in the database would be the least important factor (unless ALL the tables were very small).

HTH,
MJ

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!