Re: dbms_job jobs and resource consumer groups

From: Andrey Goryunov <>
Date: Tue, 22 Jul 2008 15:25:35 +1000
Message-ID: <>


there is SERVICE_NAME column in v$session. Is the service name when job is running?


2008/7/22 Dan Norris <>:

> I sent this a few weeks ago and one response said that using
> dbms_application_info was an option. If I don't want to change the code at
> all--can someone at least help me identify what service the dbms_job jobs
> will use? I suspect it uses the SYS$USERS service, but I'm not certain and
> I'm not certain how to tell. Can someone suggest a way to tell what service
> a DBMS_JOB is running under?
> I have a test environment, but even 10046 won't show the service the
> DBMS_JOB runs under as far as I can tell. Suggestions welcome.
> Thanks,
> Dan
> Dan Norris wrote:
>> I'm on, 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
>> --

Andrey Goryunov

Received on Tue Jul 22 2008 - 00:25:35 CDT

Original text of this message