Re: DB File Sequential Read Waits

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 29 Dec 2003 19:19:02 -0800
Message-ID: <1072754248.554601@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.

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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Dec 29 2003 - 21:19:02 CST