RE: Changing block size
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: 'Dennis Williams' <oracledba.williams@xxxxxxxxx>
- Date: Thu, 4 Dec 2008 08:38:52 -0800
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:
