Re: perplexing performance on AIX

We really want to be able to use parallel.

On Tue, May 6, 2008 at 2:21 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>
wrote:

>  If you disabled parallellism, you couldn't get PX wait events.  You might
> want to try with DOP of 1.  I'd also verify CIO is being used if you aren't
> sure.
>
>  ------------------------------
> *From:* John Smith [mailto:john40855@xxxxxxxxx]
> *Sent:* Tuesday, May 06, 2008 11:57 AM
> *To:* Allen, Brandon
> *Subject:* Re: perplexing performance on AIX
>
> Yes, we tried decreasing the DOP.   Didnt really affect the wait event.  I
> am pretty sure the drives are already mounted w/ CIO.  At least they are
> supposed to be.
>
> On Tue, May 6, 2008 at 1:20 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>
> wrote:
>
> >  Have you tried decreasing the degree of parallelism (or maybe
> > even disabling it) to see if that helps?  Sometimes too much parallelism is
> > a bad thing.
> >
> > You might also want to consider using concurrent IO if you're not
> > already.
> >
> > Regards,
> > Brandon
> >
> >
> >
> > Privileged/Confidential Information may be contained in this message or
> > attachments hereto. Please advise immediately if you or your employer do not
> > consent to Internet email for messages of this kind. Opinions, conclusions
> > and other information in this message that do not relate to the official
> > business of this company shall be understood as neither given nor endorsed
> > by it.
> >
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

Other related posts: