Re: how to set parallel_max_servers without running PQ within out apps
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 19 May 2008 07:16:02 -0700
Message-ID: <a9c093440805190716m6b4f1373m8d75c04a91472af3@mail.gmail.com>
Date: Mon, 19 May 2008 07:16:02 -0700
Message-ID: <a9c093440805190716m6b4f1373m8d75c04a91472af3@mail.gmail.com>
On Mon, May 19, 2008 at 6:18 AM, Fedock, John (KAM.RIC)
<John.Fedock_at_us.kline.com> 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-lReceived on Mon May 19 2008 - 09:16:02 CDT