Re: DB File Sequential Read Waits

rjpfal wrote:

> Anyone have suggestions on how do reduce the number of db file
> sequential reads?
> Also any suggestions on improving IO on an EMC array (concatenated
> versus striped volumes)
>
> I have a CRM application running on Oracle 8.1.6.3 Enterprise Edition.
> It is in archive log mode and is running in a Sun Solaris 2.8 machine
> with 2 dedicated CPU's.
>
> I am in the process of testing a new disk configuration on the backend
> of this server (EMC) I have the data index files assigned to
> respective file systems /u02 and /u03. The breakdown of the physical
> disk on the array is done in 8G chunks on 73G hardrives. The stripe
> size across the disk is 1M.
>
> The test I am performing is strictly a read-only set against the DB
> using most often used queries from the production database. A similar
> test was run against the production DB during off hours.
>
> I am seeing no real improvement in the total IO time between the
> production system test (concatenated volumes) and the test server
> (striped volumes) both is amount of IO and the actual times.

I stopped reading at this point.

You are using an unsupported, and quite frankly optimizer damaged, version of Oracle and you are trying to fix problems by playing with the hardware.

Waste of time. Upgrade to at least 8.1.7.4. Preferably 9.2.0.4.

-- 
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)