Re: BG Process username setting

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







  -- 
  Thanks & Regards,
  T. Onkar Nath
  Ph : +91-9826728111(Cell)
         to_onkar@xxxxxxxxx
         onkarnath.tiwary@xxxxxxxxx

--
http://www.freelists.org/webpage/oracle-l

Other related posts: