Oracle-L: RE: find the system process for an oracle session

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Fri, 22 Nov 2002 08:24:44 -0800
Message-ID: <F001.00509672.20021122082444@fatcity.com>

There is a column 'PADDR' in v$session , join this with the column 'ADDR' of v$process and look for column value 'SPID' from v$process.

Now write a query.

:)-

-----Original Message-----
Sent: Friday, November 22, 2002 8:54 AM
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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reddy, Madhusudana
INET: Madhusudana.Reddy_at_bestbuy.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------