Re: wait statistics

From: Yong Huang <yong321_at_yahoo.com>
Date: 24 Mar 2002 13:16:12 -0800
Message-ID: <b3cb12d6.0203241316.2a4678dd@posting.google.com>

Optimize your sorting, and to a lesser extent, parallel queries, create table as select, create index parallel... Anything bypassing buffer cache.

Let's say it's mostly sorting. Make sure your applications are not necessarily doing order by, group by. Sometimes it's more efficient to do the sorting in the application instead of in Oracle. Make sure your sort_area_size is large enough. The default (64k?) may be way too small in production. Make sure the temporary tablespace has a CONTENTS='TEMPORARY' or it's a proper temporary tablespace in 8i. Optimize I/O.

Yong Huang

i_rahim_at_hotmail.com (Imran Rahim) wrote in message news:<e7519cfe.0203231442.3d037c51_at_posting.google.com>...
> Does anyone know what I should be checking for if my wait statistics
> shows a high value for DIRECT PATH READS and DIRECT PATH WRITES.
>
> Many thanks!
Received on Sun Mar 24 2002 - 15:16:12 CST