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 > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l