select nvl(username, 'My BG Process') Process from v$session;
- Original Message -----
From: "Onkar N Tiwary" <onkarnath.tiwary_at_gmail.com>
To: <oracle-l_at_freelists.org>
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_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
