limit parallel process per session in 10.2.0.4

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 17 Dec 2010 12:16:28 +0100
Message-ID: <AANLkTi=5wSfZBG5ppxJiX7B8ouYEQzK_qVFGm5ZF2Xo2_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 17 2010 - 05:16:28 CST

Original text of this message