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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 08 Jun 2006 22:04:57 GMT
Message-ID: <da1ig.20857$VE1.11226@newssvr14.news.prodigy.com>


grz01_at_spray.se wrote:
> 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
>

Yes, there is. It's called DBMS_APPLICATION_INFO.

-- 
Mladen Gogala
http://www.mgogala.com
Received on Thu Jun 08 2006 - 17:04:57 CDT

Original text of this message

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