Re: BG Process username setting

*select nvl(username, 'My BG Process') Process from v$session;
*
Thanx. But this will show *My BG Process *in place of blank username and 
that too in the current session only. My requirement is to replace the 
username permanently. Say whoever will check the v$session view will get the 
specified username as the owner of that session. In other words naming BG 
Process and the names will be permanent. 
 Can we do that?
 On 5/31/05, Oracle <all_about_oracle@xxxxxxxxxx> wrote: 
> 
> select nvl(username, 'My BG Process') Process from v$session;
> 
> ----- Original Message -----
> From: "Onkar N Tiwary" <onkarnath.tiwary@xxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Tuesday, May 31, 2005 12:58 PM
> Subject: BG Process username setting
> 
> 
> > hi all,
> > I have got one doubt. Is it possible to set username for the background
> > processes which is normally blank and osuser column contains value
> "SYSTEM".
> > Why I am asking is because I have noticed that for some time my server
> > showing a BG Process username as ORACLE_RECO_070316. I don know why its
> > showing this?
> > Can anyone put some light on this?
> > --
> > Thanks & Regards,
> > T. Onkar Nath
> > Ph : +91-9826728111(Cell)
> > to_onkar@xxxxxxxxx
> > onkarnath.tiwary@xxxxxxxxx
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> 
> 
> 
> 


-- 
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx

--
http://www.freelists.org/webpage/oracle-l

Other related posts: