Re: Getting proccess ids in NT

Verma wrote in message <01bebcf8$f01e9540$1aae4e0c_at_Verma.medco.com>...
>In Unix environment, we can trace back each Oracle session to the Unix
>process by juggling with v$session and v$process. We take help of ps
>command in unix for getting the exact process id.

UNIX is great..
yeay, yeah,
UNIX is great..
If UNIX was one of us...

>How do we do this thing in Windows NT environment ?
>I tried something by invoking the Task Manager and then looking at the
>running processes. It shows the PIDs for programs running. But I could not
>trace any PIDs to the pids being displayed in the v$ views.

Yep.

>Am I doing something wrong ?

Yep. Thinking that NT is like UNIX. :-)

In UNIX, the Oracle processes like PMON, CKPT, DBWR and LGWR are forked child processes - which is why they run with unique PIDs in UNIX.

In NT, these processes are threads. I think that the "PID" you see in Oracle is the actual NT thread handle of that process thread.

The question is why do you want to "see" these threads via a NT type "ps" command? Not much you can do to a NT thread as none of the thread API calls are accessible from the NT command line - not that these are of much use anyway for a DBA I would think.

regards,
Billy Received on Wed Jun 23 1999 - 02:15:43 CDT