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: High IO Waiting...

Re: High IO Waiting...

From: Dave <shoad316_at_hotmail.com>
Date: 6 May 2003 08:17:57 -0700
Message-ID: <78cf0572.0305060717.74519254@posting.google.com>


Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<45febvglh7t9mociqtaf1c0lir4uajdlp5_at_4ax.com>...
> On 5 May 2003 13:54:14 -0700, shoad316_at_hotmail.com (Dave) wrote:
>
> Check out from the v$ tables WHAT it is waiting for, and tune from
> there.
> The other approach doesn't make sense, as it never won't identify
> bottlenecks

   I already did that and I think I mentioned it. I can't remember the exact event (direct IO wait?) but they were the biggest ones... I ran utl[b|e]stat during one of the refreshes.

Dave Received on Tue May 06 2003 - 10:17:57 CDT

Original text of this message

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