ORacle PID = WinNT PID ?????

From: Foelz.Frank <Foelz.Frank_at_Scheidt-Bachmann.de>
Date: Thu, 16 Jan 2003 03:58:43 -0800
Message-ID: <F001.00531159.20030116035843@fatcity.com>

Hi all,

can anyone tell me, if the Oracle PID has to be the same as the Windos process id ?

I ran the following script, to find ou, if a hanging process is still connected to the database:

     select
     substr(a.spid,1,5) pid,
     substr(b.sid,1,5) sid,
     substr(b.serial#,1,5) ser#,
     machine box,
     substr(b.username,1,10) username,
     -- b.server,
     substr(b.osuser,1,8) os_user,
     substr(b.program,1,30) program
     from v$session b, v$process a
     where
     b.paddr = a.addr
     and type='USER'
     order by spid;

PID   SID   SER#  BOX                                             USERNAME
OS_USER  PROGRAM                       
----- ----- ----- ----------------------------------------------- ----------
-------- ------------------------------
00111 58    10121 networkname                                     xx

xxxxxxx C:\myexe.exe

If find the process myexe.exe on networkname in the taskmanager the PID is : 478 (HEX 1DE). The database is
on a separate server in the network.

TNX
> Frank <

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: Foelz.Frank_at_Scheidt-Bachmann.de

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 Thu Jan 16 2003 - 05:58:43 CST