Re: Resource Manager and PARALLEL_DEGREE_LIMIT_P1

schonlinner_at_yahoo.com wrote:
> Hi,
>
> we have an Oracle 10g database here and want to use the resource
> manager. We created a plan and set PARALLEL_DEGREE_LIMIT_P1 of a
> consumer group to 1.
>

...
> DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(PLAN => 'our_plan',
> GROUP_OR_SUBPLAN => 'OURAPP', COMMENT => 'Emergency sessions',CPU_P2 =>
> 80,PARALLEL_DEGREE_LIMIT_P1 => 6);
I only see you set it to 6. Where is it set to 1?

Yong Huang Received on Wed Aug 24 2005 - 22:11:49 CDT