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

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