Re: BG Process username setting
- From: "Oracle" <all_about_oracle@xxxxxxxxxx>
- To: "Onkar N Tiwary" <onkarnath.tiwary@xxxxxxxxx>
- Date: Tue, 31 May 2005 15:24:01 +0800
Only Steve Adams caliber know Oracle Internally, can't help you to achieve your
request...
----- Original Message -----
From: Onkar N Tiwary
To: Oracle
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Tuesday, May 31, 2005 3:17 PM
Subject: 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
