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

From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
To: John.Fedock@xxxxxxxxxxxx
Date: Mon, 19 May 2008 07:16:02 -0700

On Mon, May 19, 2008 at 6:18 AM, Fedock, John (KAM.RIC)
<John.Fedock@xxxxxxxxxxxx> wrote:
> Normal, homegrown queries started running in parallel.  How can this happen
> if the degree is 1 for all objects?

Parallel hint?

> Is there a way to set parallel_max_servers > 1 for streams, and not have PQ
> option running on our application objects?

You can use resource manager and set the max DOP to 1 for a given user class.


-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

References:

how to set parallel_max_servers without running PQ within out apps
From: Fedock, John \(KAM.RIC\)

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

Other related posts: