Re: wait statistics

From: Imran Rahim <i_rahim_at_hotmail.com>
Date: 25 Mar 2002 02:48:19 -0800
Message-ID: <e7519cfe.0203250248.f139ffb@posting.google.com>

The sorts are

      188 sorts (memory)
       64     837382

      189 sorts (disk)
       64        794

      190 sorts (rows)
       64   18068722

Is the disk statistic sufficiently high to be worried?? thanks
Imran

"K Gopalakrishnan" <kaygopal_at_yahoo.com> wrote in message news:<3c9e48c8_at_news.mhogaming.com>...
> THat should be a typical IO problem. Use OS level statistics to findoud the
> IO bottlenecks of the files affected by the parameter P1
> (file # or absolute file #)
>
>
> "Imran Rahim" <i_rahim_at_hotmail.com> 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 Mon Mar 25 2002 - 04:48:19 CST