Search notes:

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:

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788594201, '216.73.216.30', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/internals/process/Windows/index(41): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78