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?
On 9 Jun 2006 01:50:13 -0700, 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
sqlplus.exe can set the program column
oracle.exe can not
jobs run on the server, with no interaction from any client, using the
oracle executable.
Hence there is no means to set the program column.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Jun 09 2006 - 04:46:37 CDT