Re: BG Process username setting

  • From: "Oracle" <all_about_oracle@xxxxxxxxxx>
  • To: <onkarnath.tiwary@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 31 May 2005 14:20:08 +0800

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

Other related posts: