Re: how to find out user name from session#

Hi,
 just curious, why are you joining with v$session_wait ?

Karsten
In article <7vu6kr$a3n$1_at_nnrp1.deja.com>,   Tony Adolph <tony.adolph_at_viaginterkom.de> wrote:
> 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.
>

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