Re: Changing block size
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Dec 2008 08:48:58 -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.
Other related posts:
