HOW TO MATCH MS WINDOWS THREAD ID WITH ORACLE SESSION ID
235138May 25 2007 — edited May 25 2007I face the problem in Production environment. We have an Application Server (Windows 2000 Advance server) with IIS installed and Database Server (AIX system). When the problem occur, we will see a DLLHOST.exe process along with thread ID seems to hang and blocking other session. I would like to match this Windows thread ID (from Windows Application Server) with Oracle session ID (on database server on AIX) to check the current running SQL command for investigation why it cause blocking other session. Which views or tables have those information?
In my environment, the Windows server is a middle tier (Application server)
which only has Oracle client installed. The DLLHOST.EXE processes from this
server is connecting to the database server (which is on another box). I would
like to match the process ID of DLLHOST.EXE from Application server with the
Oracle session ID found on the database server. My problem is, there is a
DLLHOST.EXE process hang on an Application server and I know its process ID
(using a program similar to QuickSlice) but I don't know what SQL query or
action it is performing that caused the process to hang. When I query on
v$session and v$process, I don't know which Oracle session ID belongs to that
hang DLLHOST.EXE process.