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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 16 Aug 2004 07:05:45 -0400
Message-ID: <pan.2004.08.16.11.05.44.756630@sbcglobal.net>


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

-- 
A city is a large community where people are lonesome together.
Received on Mon Aug 16 2004 - 06:05:45 CDT

Original text of this message

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