Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Setting v$session.program for dbms_job process?
grz01_at_spray.se wrote:
> Hi,
>
> I have several long-running processes started by dbms_job.submit()
>
> It seems all such processe by default gets a blank value in
> v$session.program
>
> Is there anyway I can set that field from PL/SQL to a
> specific string-value when I start the job, so each session
> can then be identified in v$session by this value?
>
> Thanks
> ------------------ grz01
>
Yes, there is. It's called DBMS_APPLICATION_INFO.
-- Mladen Gogala http://www.mgogala.comReceived on Thu Jun 08 2006 - 17:04:57 CDT
![]() |
![]() |