RE: find the system process for an oracle session

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 22 Nov 2002 09:24:16 -0800
Message-ID: <F001.00509740.20021122092416@fatcity.com>

Ruth,

Try this query...Will give you both PID and SPID. If you want to have it for all uesers connected with Database then remove vs.status = 'ACTIVE'.

set linesize 120
select substr(vs.username,1,10)username,

       vs.osuser,
       vs.sid,
       vs.serial#,
       vs.LOGON_TIME,
       substr(vs.machine,1,15)machine,
       vs.process,
       vp.spid,
       vs.last_call_et

from v$session vs, v$process vp
where vs.paddr = vp.addr
and vs.username is not null
and vs.status = 'ACTIVE'
/

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Fri, 22 Nov 2002 08:24:44 -0800

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


---------------------------------------------------------------------

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

---

Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

--

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

Author: M Rafiq
  INET: rafiq9857_at_hotmail.com

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 - 11:24:16 CST