Re: Identifying session (7.1.6)

From: Nevin Hahn <nhahn_at_ENTENTE.UHCOLORADO.EDU>
Date: 1997/03/07
Message-ID: <5fnpbp$3mg@tali.UCHSC.edu>#1/1

Veijo Länsikunnas <Veijo.Lansikunnas_at_tietogroup.com> wrote:
>Hello,
>
>Does anybody have ideas how to identify the current session?
>I have a need to occationally know the name of the OS-user of
>the current session, and I haven' found out any way to do this.
>Any idea?
>

Veijo,

select username,osuser,process,terminal from v$session;

should do the trick.

There are a number of other columns in the v$session view that might also be useful.

Nevin Hahn Received on Fri Mar 07 1997 - 00:00:00 CST