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