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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
