Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Direct path write

Re: Direct path write

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 16 Aug 2004 21:59:56 +1000
Message-ID: <4120a1db$0$18669$afc38c87@news.optusnet.com.au>


Mladen Gogala wrote:

> On Mon, 16 Aug 2004 02:23:27 -0700, Gopal wrote:
>

>> Please help in narrowing down how can I
>> avoid the direct path write/read wait event.

>
> Increase SORT_AREA_SIZE. Direct path read/write events are
> usually reads/writes to temporary segments, although reads
> can also be caused by PQO which can go directly from the
> disk into the PGA for that process. You said that you're
> rebuilding indexes, which usually entails some sorting,
> and that is the most probable cause for direct path read/write.
> Try doing index rebuilds parallel, nologging. That should be
> much faster

Even faster, and almost certainly more productive, is:

Try not rebuilding indexes at all, since they almost certainly don't need it.

Regards
HJR Received on Mon Aug 16 2004 - 06:59:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US