RE: BG Process username setting

It is possible to do what you ask however it is not something you should =
do.

Who needs to see the v$session view?  Are they logged on with "connect =
internal" or sys?  If not, you can create a view along the lines of the =
v_$session view in which you have a case statement which sets the value =
of username if it is blank and the OS user is SYSTEM.  You could then =
have a public synonym, v$session, which points to this view.

The v$session view should not be made public.  At one time the program =
field would contain the username and password  of a user under certain =
conditions.  Also, if you look at the plustrce.sql script in =
$OH/sqlplus/admin in a new enough release , you will see that Oracle has =
removed v$session as one of the views available to the plustrace role.  =
I think this happened as of 9.2.0.4.=20

What do you mean by permanent?  The x$tables, the bases for the v$views, =
aren't database tables.  They allow you to peek at parts of the SGA.  =
The x$table information is not stored in the database.

Now as far as the ORACLE_RECO_070316 goes, do you have any in doubt =
distributed transactions?  I think RECO is trying to resolve one these =
but is having problems.=20

If you feel Oracle is showing something strange, you shouldn't try to =
hide it, but find out what is causing it and fix it.

Ian MacGregor
Stanford Linear Accelerator Center
ian@xxxxxxxxxxxxxxxxx

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Oracle
Sent: Tuesday, May 31, 2005 12:24 AM
To: Onkar N Tiwary
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: BG Process username setting

Only Steve Adams caliber know Oracle Internally, can't help you to =
achieve your request...=20
  ----- Original Message -----=20
  From: Onkar N Tiwary=20
  To: Oracle=20
  Cc: oracle-l@xxxxxxxxxxxxx=20
  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. =20
  =20
  Can we do that?

  =20
  On 5/31/05, Oracle <all_about_oracle@xxxxxxxxxx> wrote:=20
    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=20


    > 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=20
    > 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)=20
    > to_onkar@xxxxxxxxx
    > onkarnath.tiwary@xxxxxxxxx
    >
    > --
    > http://www.freelists.org/webpage/oracle-l
    >







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

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

Other related posts: