Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> map window 2000 PID to Oracle SPID
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.comReceived on Fri Jan 11 2002 - 04:12:45 CST