PL/SQL (MOSC)

MOSC Banner

DBMS_PARALLEL_EXECUTE

edited Dec 22, 2017 4:00AM in PL/SQL (MOSC) 3 commentsAnswered

Hello, I try to use DBMS_PARALLEL_EXECUTE package in 11g RAC enviroment.

Sometimes all jobs spawned by this package run only on one instance in the cluster.

Is there any way how to assign jobs generated by this package to specific instance ? 

For example: I execute task (DBMS_PARALLEL_EXECUTE.RUN_TASK) with parallel level 6, so I want 3 jobs running on instance 1 and 3 jobs running on instance 2.

The only thing I have found is that I can assign main task to a job class and job class can be assigned to a specific service.

But this is not what I need.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center