Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> map window 2000 PID to Oracle SPID

map window 2000 PID to Oracle SPID

From: yewpc <member_at_dbforums.com>
Date: 11 Jan 2002 05:12:45 -0500
Message-ID: <3c3eba9d$1@usenetgateway.com>


Hi all, I am new to Oracle in Window 2000. In unix ie HP, i can easily determine which sql statement is being executed by which OS process . I mean the OS sqlnet process to Oracle database. This enable me to kill that process if needed.

For Window 2000, How can i archive the same goal ? for example, i get the SPID from the v$process for a particular long run sql, how do i map it to the window 2000 process id ?

I can't find the matching SPID to the PID in Window Task manager's processes. In other way, how do i determine what is the Window PID for the Oracle backgroup process ie SMON ?

Anyone has any crue ?

Thank you

--
Posted via dBforums
http://dbforums.com
Received on Fri Jan 11 2002 - 04:12:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US