Re: map window 2000 PID to Oracle SPID

Hi there,

you have to figure out the thread id.

for background processes you can use

 select p.spid "ID_THREAD",

        b.name "NAME"
 from v$process p, v$bgprocess b, v$session s   where s.paddr = p.addr and b.paddr(+) = p.addr and    s.type = 'BACKGROUND';

hth

s.kapitza

yewpc <member_at_dbforums.com> wrote in message news:<3c3eba9d$1_at_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
Received on Sat Jan 12 2002 - 06:45:51 CST