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 -----
To: <ORACLE-L_at_fatcity.com>; <rgramolini_at_tax.state.vt.us> Sent: Friday, November 22, 2002 10:28 AM

> 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: 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).