Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: BG Process username setting

Re: BG Process username setting

From: Oracle <all_about_oracle_at_hotpop.com>
Date: Tue, 31 May 2005 14:20:08 +0800
Message-ID: <006f01c565a8$d1429540$0200a8c0@ncs.corp.intads>


select nvl(username, 'My BG Process') Process from v$session;

> 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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 31 2005 - 02:24:36 CDT

Original text of this message

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