Re: limit parallel process per session in 10.2.0.4

From: amonte <ax.mount_at_gmail.com>
Date: Mon, 20 Dec 2010 10:27:26 +0100
Message-ID: <AANLkTikG9tktHyiQqUO__V=nGM5ihWhv_nqXUeTejZfL_at_mail.gmail.com>



oh, I thought CPU is compulsory

I tested it without setting CPU and it is working with only parallel degree set

Thanks a lot

Alex

2010/12/18 Greg Rahn <greg_at_structureddata.org>

> 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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 20 2010 - 03:27:26 CST

Original text of this message