RE: find the system process for an oracle session

Ginko Biloba?
Isn't he a Brazilian footballer?

Pete

> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> Sent: 22 November 2002 15:51
> To: MOORE, Peter Rbh; ORACLE-L_at_fatcity.com
> Subject: Re: find the system process for an oracle session
>
>
> Thanks! I had a senior moment there. Guess I'll get some
> coffee to wash
> down my Ginko Biloba.
>
> Ruth
> ----- Original Message -----
> From: "MOORE, Peter Rbh" <Peter.MOORE.RBH_at_reading.sema.slb.com>
> To: <ORACLE-L_at_fatcity.com>; <rgramolini_at_tax.state.vt.us>
> Sent: Friday, November 22, 2002 10:28 AM
> Subject: RE: find the system process for an oracle session
>
>
> > select p.spid, s.sid, s.username, s.program
> > from v$session s, v$process p
> > where p.addr = s.paddr
> >
> > p.spid shows you the o/s process ID for the session.
> >
> > --
> > Peter Moore
> > Systems DBA,
> > Mid-Range Centre of Expertise,
> > Global Service Delivery,
> > SchlumbergerSema,
> > Reading
> >
> > Phone: 0118 963 6827
> > Email: pmoore7_at_slb.com
> >
> >
> > > -----Original Message-----
> > > From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> > > Sent: 22 November 2002 14:54
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: find the system process for an oracle session
> > >
> > >
> > > Good morning,
> > >
> > > Can anyone send my the sql to find the system process
> being used by an
> > > oracle session. I know this has been out here before, but I
> > > can't find it
> > > in my saved stuff.
> > >
> > > Thanks in advance,
> > > Ruth
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > > INET: rgramolini_at_tax.state.vt.us
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> hosting services
> > >
> ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed
> from). You may
> > > also send the HELP command for other information (like
> subscribing).
> > >
> >
> >
> > _________________________________________________________
> > This email is confidential and intended solely for the use of the
> > individual to whom it is addressed. Any views or opinions
> presented are
> > solely those of the author and do not necessarily represent those of
> > SchlumbergerSema.
> > If you are not the intended recipient, be advised that you
> have received
> > this email in error and that any use, dissemination,
> forwarding, printing,
> > or copying of this email is strictly prohibited.
> >
> > If you have received this email in error please notify the
> > SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
> > _________________________________________________________
> >
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MOORE, Peter Rbh
  INET: Peter.MOORE.RBH_at_reading.sema.slb.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).