Re: user description on console

Laslop_at_t-online.de (Laslop Hans) writes: > Hello everybody,
>
> we connect all users of our application with the same database username.
> Now I'm searching for a posibility to show a description text for every
> connected instance, because we can't see which user we have to terminate
> when there are locking problems..
>
> Who can help me???
>
> TIA
>
> Hans Laslop
>
> ======= ====== =====
> = eMail: Laslop_at_T-Online.de
> ======= ====== =====

Hi there,

If you are using Client server architecture, then there is a easy solution. On each of the client, there will be a file called ORACLE.INI.

Edit that file and add the following line

USERNAME=<actual user>

This will appear in v$session table under OSUSER column. You can issue the following query

SELECT SID, SERIAL#, OSUSER, USERNAME
FROM V$SESSION From the above query, you know which OS-user has activated the job and you can retrieve your necessary details.

If you using a host based machine, then you can try using the terminal id to find out the process. This info can be found in V$session or V$process.

Hope the above info helps you,

Regards

N.Prabhakar Received on Mon Nov 18 1996 - 00:00:00 CET