Re: how to find out user name from session#

Hi Kartsen,

Good question! I have cut-n-pasted the wrong query! It was a hacked query looking at wait events, but nothing useful to the origonal poster, it should have been:

column sid format 999
column serial# format 99999
column username format a10
column ora_user format a8
column os_user format a8
column program format a24
column cursors format 99
column terminal format a9
break on terminal skip 1
set linesize 120

select

	s.sid, s.serial#, s.terminal,
	s.username ora_user, p.username os_user,
	 s.status, s.osuser, s.program
from
	v$session s, v$process p
where
	s.sid=p.pid
order by
	s.terminal

Sorry about the misleading info folks!
Tony

In article <7vusb7$p0d$1_at_nnrp1.deja.com>,   karsten_schmidt8891_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 01:53:28 CST