Re: dbms_job jobs and resource consumer groups

From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 09 Jul 2008 07:42:11 -0600
Message-ID: <4874C033.2020108@dannorris.com>

Thanks, Allan. I'm not sure code changes are possible in this case, but that solution should solve the issue. I'm still hoping for something that doesn't require the code to change (since code submits the jobs), but I already suspected that isn't likely.

Dan

Allan Nelson wrote:

You could use dbms application info package to set the module or action field and use that to map it into the right resource consumer group.

Allan

On Mon, Jul 7, 2008 at 5:38 PM, Dan Norris <dannorris@dannorris.com> wrote:

I'm on 10.2.0.3, 3-node RAC (not that RAC matters in this case), RH4.

I'm considering implementing resource consumer groups and having trouble finding any way to place a dbms_job into a particular consumer group. If my groups are mapped using the service_name that the user connected with, is there any way to assign a job to a particular consumer group? That is, without placing a call to DBMS_RESOURCE_MANAGER into the job? If I map the groups some other way (other than by username), is there a mapping that would handle all dbms_jobs easily?

I know that migrating to DBMS_SCHEDULER is the "right" way forward, but that migration may take some time as the calls to DBMS_JOB are embedded in app code, so we're looking for a good interim solution.

Thanks,
Dan
--
http://www.freelists.org/webpage/oracle-l

-- http://www.freelists.org/webpage/oracle-l Received on Wed Jul 09 2008 - 08:42:11 CDT