FAQ
Dan,

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

Cheers
Andrey

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 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

--
Regards,
Andrey Goryunov

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 6 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 7, '08 at 10:38p
activeJul 22, '08 at 1:51p
posts6
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase