Re: limit parallel process per session in 10.2.0.4

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: ax.mount@xxxxxxxxx
  • Date: Sat, 18 Dec 2010 11:03:34 -0800

Just use parallel degree limit for each consumer group and dont set
anything with the CPU yielding.

On Fri, Dec 17, 2010 at 3:16 AM, amonte <ax.mount@xxxxxxxxx> wrote:

> I was wondering if we can limit parallel slaves spawned per session.
>
> I know that with database resource manager we could do it but it seems to me
> that we must have different CPU for each consumer group. We dont want to
> limit CPU usage only parallel slaves. So basically we need two consumer
> group who share 100% CPU Usage but different parallel settings, is this
> possible in 10.2.0.4?

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


Other related posts: