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_at_oneneck.com> 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_at_gmail.com]
> *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_at_oneneck.com>
> 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.
>

--
http://www.freelists.org/webpage/oracle-l