Re: how to set parallel_max_servers without running PQ within out apps

From: 조동욱 <ukja.dion_at_gmail.com>
Date: Thu, 22 May 2008 09:03:53 +0900
Message-ID: <43c2e3d60805211703n284740fbv31a7ac9d0c0f0870@mail.gmail.com>


Can you trace your problematic query with "_px_trace" parameter? (Search _px_trace in Metalink)

Not sure this would expose your problem, but who knows?

Dion Cho

2008/5/19, Fedock, John (KAM.RIC) <John.Fedock_at_us.kline.com>:
>
> For streams, we need to set parallel_max_servers to > 1.
>
>
>
> I made sure all tables and indexes have parallel set to 1 and then set the
> above parameter.
>
>
>
> Normal, homegrown queries started running in parallel. How can this happen
> if the degree is 1 for all objects?
>
>
>
> Is there a way to set parallel_max_servers > 1 for streams, and not have PQ
> option running on our application objects?
>
>
>
>
>
> This is a 2 node RAC, HP-UX system running 10.2.0.3.
>
>
>
>
>
> TIA,'
>
>
>
>
>
> John
>
>
>
>
>
>
>
> *John Fedock*
>
> *"K"* Line America, ISD Department
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 21 2008 - 19:03:53 CDT

Original text of this message