That was what I was missing--thanks!
FYI, looks like it is SYS$USERS (even if you submit the job while
connected to a different service, the job still uses SYS$USERS).
Dan
Andrey Goryunov wrote:
Dan,
there is SERVICE_NAME column in v$session. Is the service name when job
is running?
Cheers
Andrey
2008/7/22 Dan Norris < dannorris@xxxxxxxxxxxxx>:
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
--
//www.freelists.org/webpage/oracle-l
--
Regards,
Andrey Goryunov
--
//www.freelists.org/webpage/oracle-l
|