Oracle internals: process (Windows)

On Windows, an Oracle process is implemented as a thread. With Microsoft's Symbolic Debugger for Windows (cdb.exe), it's possible to show the relationship between the «processes» as exposed in v$process and the actual Windows threads.

First, the available processes must be selected from v$process. Then cdb.exe must be started and attached to Oracle:

C:\> cdb -pn oracle.exe

After starting the debugger, all threads of the debuggee can be displayed with the tilde (~).

It turns out that the thread IDs are related to the value sosid in v$process: