Re: how to find out user name from session#

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Fri, 05 Nov 1999 09:05:32 GMT
Message-ID: <7vu6kr$a3n$1@nnrp1.deja.com>

In article <2750ac20.4ddb6d75_at_usw-ex0101-003.remarq.com>, hongw1999 <hwangNOhwSPAM_at_channellcorp.com.invalid> wrote:
> We are running Oracle application on Oracle 8. Most of user login
> as apps. I run select from v$session can find out sid, seriral#, but
> I don't know how to link to fnd_user table to find out the persons
> login name.
>
> Could anyone tell me? Thanks

select s.sid, s.serial#, s.terminal, s.username, s.osuser, s.program from

v$session s, v$session_wait w
where

s.sid=w.sid;

The above works ok on NT.

Hope that helps
Tony Adolph

>
> Howard
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
Network *
> The fastest and easiest way to search and participate in Usenet -
Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 03:05:32 CST