Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting v$session.program for dbms_job process?
Thanks for the hint, Mladen,
Using DBMS_APPLICATION_INFO in seems I can set the v$session fields Action, Module, and Client-info.
However, I could not find a function there to set v$session.program, which is what I would really like to do.
Anyone knows how to do this?
TIA,
---------------------- grz01
Mladen Gogala wrote:
> 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.com
Received on Fri Jun 09 2006 - 02:01:53 CDT