Re: how to set parallel_max_servers without running PQ within out apps
- From: "조동욱" <ukja.dion@xxxxxxxxx>
- To: John.Fedock@xxxxxxxxxxxx
- Date: Thu, 22 May 2008 09:03:53 +0900
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@xxxxxxxxxxxx>:
>
> 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
>
>
>
Other related posts:
