Re: Excessive Logical and Physical I/O

Matt wrote:

> Hello all,
>
> Oracle 8.1.7.2.1 HP-UX 11 (64-bit)
>
> My first suspicions were due to the sort, but I would have expected
> the sorts to be done via direct I/O (i.e. bypassing the buffer cache).
>
> Anyone have any ideas why this is performing so much work...
>
> Matt

My first idea is that you should be patched to 8.1.7.4 before doing anything else.

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