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 -> Setting v$session.program for dbms_job process?

Setting v$session.program for dbms_job process?

From: <grz01_at_spray.se>
Date: 8 Jun 2006 14:55:29 -0700
Message-ID: <1149803729.318560.255620@c74g2000cwc.googlegroups.com>


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
Received on Thu Jun 08 2006 - 16:55:29 CDT

Original text of this message

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