Re: map window 2000 PID to Oracle SPID

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 11 Jan 2002 13:35:43 +0000
Message-ID: <3C3EEA2F.83CC5D11@exesolutions.com>

Windows doesn't have multiple processes like UNIX. To kill on a Windows platform use orakill.exe or do it as SYS.

Daniel Morgan

yewpc wrote:

> 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 - 07:35:43 CST