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>


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-l
Received on Mon May 19 2008 - 09:16:02 CDT

Original text of this message