limit parallel process per session in 10.2.0.4

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 17 Dec 2010 12:16:28 +0100

Hi all

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?

Thanks

Other related posts: