Re: Setting v$session.program for dbms_job process?

grz01_at_spray.se wrote:
> Sybrand Bakker wrote:
> > On 9 Jun 2006 00:33:58 -0700, grz01_at_spray.se wrote:
> >
> > >OK, the thing is when starting a job with DBMS_JOB(),
> > >it seems I always get a null value in this field.
> > >I would like to set it to something else.
> > >
> > >There must be a way that other applications (like sqlplus, toad, etc)
> > >propagate this value to Oracle.
> > >The Oracle-engine cannot know the name of the executable on a remote
> > >host, can it?
> > >But still the program-name shows up for those applications...
> > >
> > >Regards
> >
> >
> > you can set the application_info column and the module colum using the
> > dbms_application_info package.
> >
> >
> > Please stop top-posting. Humans happen to read from top to bottom not
> > from bottom to top.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> Thanks Sybrand,
>
> Yes, I already got that info from Mladen.
> But what about v$session.program ?
> How does applications set that value ?
> Is it not possible from PL/SQL process ?
>
> Regards
> ------------------- grz01

1. a job queue is not an application
2. probably the program column is derived from the listener (check listner.log, program=... ) while establishing a connection

hth.

s.kapitza Received on Fri Jun 09 2006 - 04:08:51 CDT