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

This message: [ Message body ]
Next message: Mark W. Farnham: "FW: concepts document part about separating indexes and tablespaces"
Previous message: Fedock, John \(KAM.RIC\): "how to set parallel_max_servers without running PQ within out apps"
In reply to: Fedock, John \(KAM.RIC\): "how to set parallel_max_servers without running PQ within out apps"
Next in thread: Jonathan Lewis: "Re: how to set parallel_max_servers without running PQ within out apps"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message