Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: find the system process for an oracle session
Ruth,
select vp.spid
from v$process vp, v$session vs
where vp.addr=vs.paddr
and vs.sid=&1
regards,
Mike Hately
-----Original Message-----
Sent: 22 November 2002 14:54
To: Multiple recipients of list ORACLE-L
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).
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). Received on Fri Nov 22 2002 - 09:34:41 CST