RE: Changing block size

Dennis ,
When I asked the question, I had in mind just that: potentially increasing 
performance.
I am going to give you some background info. We're running Oracle 8.1.6.3 on 
WinNT4. Yes it is not an typographical error. Our warehouse management system 
is about 10 years old and initially was designed to run on that version of 
Oracle. I've contacted the vendor and ask if their app will run on any other 
version. The answer was 8.17.
I then built myself a new server with newer OS version and installed 8.1.7.4. 
This configuration is in testing right now and it looks like it is going to run 
just fine.
So, the block size was the next step to boost performance, if possible. I can 
just see  you asking: "Why don't you upgrade the app that runs on the newer 
version of Oracle?".
Then answer is simple: money. It will cost us $1M and nobody is rushing to sign 
that check.

Thanks again for all your replies,

Eugene Pipko
P  Please consider the environment before printing this e-mail.

From: Dennis Williams [mailto:oracledba.williams@xxxxxxxxx]
Sent: Thursday, December 04, 2008 7:06 AM
To: Eugene Pipko
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Changing block size

Eugene,

As you've probably understood from your replies, DB_BLOCK_SIZE is the one 
parameter that can't be changed after the database is created (there are more 
options with 10g). Perhaps if you stated why you want to change this, we can 
provide you more useful suggestions. Often people assume stuff like by doubling 
the block size their performance will double. Also, this is a pretty old 
database version, and not the latest Windows server version. I'm always 
reluctant to make substantial changes on something that old. Might be a better 
idea to migrate the database to recent versions.

Dennis Williams

Other related posts: