Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Direct path write
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