Re: DB File Sequential Read Waits

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1072754248.554601_at_yasure>...
> rjpfal wrote:
>
> > norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0312291455.64db1f2d_at_posting.google.com>...
> >
> >>I agree with the above post...an Oracle upgrade would be the best use
> >>of your time. There are significant perf improvements in 9i if you
> >>upgrade to 9i. It is ** possible ** the hardware tweaks you are
> >>making could be avoided entirely.
> >
> >
> > I appreciate the advice but I am stuck with the version of Oracle due
> > to application dependency. There is planned migration in the coming
> > year but need to address situation as it stands now.
>
> There is no such thing as application dependency.

Yes, there is. May be due to bad programming, but there you go.

>
> Get 8.1.7.4.
> Open the init.ora with a text editor
> Type the following:
>
> compatible=8.1.6.3
>
> There is no application I have ever encountered that could possibly know
> about or care about the difference. They do, however, run better. And if
> your support contract with Oracle is current the cost is zero.

I've encountered applications that break due to changes in the way things work, sometimes due to fixing bugs. Even 8.1.7.2 to 8.1.7.4 (fixing inline views broke some SQL code dependent on the bug! Also broke some vendor installation/upgrade routines based on Oracle libraries and makefiles). How global do you think compatible is?

Testing cost is never 0, including no testing at all.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/sun/business/news_1b28jaffe.html