Thanks! I had a senior moment there. Guess I'll get some coffee to wash down my Ginko Biloba.
Ruth ----- Original Message ----- To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > -----Original Message----- > > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
