Re: User list current logon

In article <956026242098_at_NewsSIEVE.cs.bonn.edu>,   "Wu Hai" <whai_at_hotmail.com> wrote:
> Hi
>
> Normally how many oracle deamon will be running if you say: #ps -ef |
 grep
> ora ?
> I think we can specify the runaway process by observing the SPID
 field in
> v$process.
> I don't know how to join v$session and v$process 'cause I am new to
 sql
> world. Please kindly advice.
>
> Thanks,
> Wu Hai
>
> Mark D Powell <markp7832_at_my-deja.com> wrote in message
> news:8df56p$l3c$1_at_nnrp1.deja.com...
> > In article <8dejlf$c9a$1_at_mango.singnet.com.sg>,
> > "Yu Jie" <dds006_at_singnet.com.sg> wrote:
> > > Hi, All
> > >
> > > I have to know all of the user current logon to Oracle server.
> > >
> > > Sometimes, our user logon to Oracle server to do some thing, but
 system(PC)
> > > hang on the half way. The user press "CTRL+Alt+Del" to munually
 kill
 the
> > > precess. The session should be killed after that. But it still
 exist
 in
> > > top-session(Enterprise Manager).Now we have to know which session
 acuatlly
> > > had been killed already. Is there any way to get this information?
> > >
> > > We are using Oracle 7.3.4 and HP unix.
> > > The sys_context doesn't work.
> > >
> > > It's very urgent!
> > >
> > > thanks
> > >
> > > Yu Jie
> > >
> > V$session shows all Oracle sessions, thier current status and has
> > columns for the machine, terminal, and program being executed. If
 you
> > join the v$sesion table to v$process you can locate the back-end
 Oracle
> > shadow process for the front-end application and then kill the
> > runaway/orphaned shadow process.
> >
> > There is a net8/sqlnet parameter to locate and terminate dead
> > connections that you may want to try implementing.
> > --
> > Mark D. Powell -- The only advice that counts is the advice that
> > you follow so follow your own advice --
> >
> >

Here is the join condition for v$session to v$process. You can fill in the rest.

select s.columns, p.columns etc...
from v$session s, v$process p
where s.username = upper('&user_id') <== chg to be col of interest and s.paddr = p.addr
/

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.