Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Setting v$session.program for dbms_job process?

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

From: <grz01_at_spray.se>
Date: 9 Jun 2006 01:50:13 -0700
Message-ID: <1149843013.239197.136120@y43g2000cwc.googlegroups.com>

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
Received on Fri Jun 09 2006 - 03:50:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US