Ginko Biloba? Isn't he a Brazilian footballer? Pete
> -----Original Message----- > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] > Sent: 22 November 2002 15:51 > To: MOORE, Peter Rbh; [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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: [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: MOORE, Peter Rbh 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).
