Thursday, May 04, 2006

Followup: Oracle block size limit on different platforms

There was a long and annoying dispute on one of the forums about why a maximum block size on Windows (and Linux) platform is 16K, while on "serious" platforms like HP, and Sun, it is 32K. I had a wild suggestion, a bold guess, that the limit has been set based on some business strategy, that should push users to migrate from "minor" platforms towards "serious" ones. My assumption was (and still is) based on a fact, that couple of years ago Oracle had different prices for Intel and RISC CPUs, and having a 32Kb block size could be one more reason for users to migrate on more expensive RISC platforms.I never believed in arguments of other people that the 16K limitation had been caused by some technical deficiencies of "minor" platforms. Sure, it is clear that in Windows, in Linux and even in DOS, it is possible to do I/O by 32Kb chunks. However, nobody could neither confirm nor disprove that the idea of 16Kb limit was a business driven decision. Bill S, has kindly contacted Tom Kyte and the OakTable members. But, to my understanding, nobody could remember the reasoning (http://dizwell.com/forum/index.php?topic=253.30). So, I have decided to contact Oracle Support. I have created a "Request for Improvement". My idea was: Support people may point out for me a technical incapability of "minor" platforms, if there is such.Oracle had accepted this RFI and registered as a Bug(!) #5196815. Funny, they call requests for improvements "bugs". May be because people are bugging them by their requests? :)))
BLOCK SIZE LIMIT THE SAME ON ALL PLATFORMS Doc ID 5196815
https://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=5196815

However, they have not answered why it had been decided to have 16K on Windows and Linux. That indirectly confirms my suggestion about a "business driven decision".

2 Comments:

Blogger Mark Malakanov said...

This comment has been removed by a blog administrator.

8:42 AM  
Blogger mahakk01 said...

In this post block size limit in Oracle is described on different platforms. The block size limit varies on different platforms. The block is written in simple language. You can learn this concept thoroughly.Thanks for the post.
sap ecc 7.0

10:13 PM  

Post a Comment

<< Home