Re: dbms_job jobs and resource consumer groups
Date: Mon, 21 Jul 2008 17:04:43 -0500
Message-ID: <488507FB.5090500@dannorris.com>
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 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-lReceived on Mon Jul 21 2008 - 17:04:43 CDT