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:
> 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
>
>
Sure...rename the executable (this works, BTW). Seriously, as Mladen suggested, just use dbms_application_info to populate the module and action...
SQL> exec dbms_application_info.set_module('My module','INSERTING...');
PL/SQL procedure successfully completed.
SQL> select module,action from v$session where sid = (select distinct
sid from v
$mystat);
MODULE
Steve Received on Fri Jun 09 2006 - 09:39:11 CDT