RE: See processes in windows

From: Tanel Poder <tanel_at_poderc.com>
Date: Wed, 22 Apr 2009 23:59:21 +0800
Message-ID: <D3AF01C3EBBF43E4A5C87AE727A76532_at_porgand>

Warning, Process monitor (procmon.exe) has crashed my PC in past. Also during my seminar one attendee once said they had a case where process explorer (procexp.exe) crashed their server with blue screen. Not saying that this will definitely happen to you but be careful in production. Btw this can happen because these tools are not regular userland tools, they install a kernel driver for reading kernel memory directly afaik.  

If you have windows debugging tools installed, you can run tlist <pid> or tlist oracle.exe to get thread info:  

C:\Documents and Settings\Tanel>tlist oracle.exe 2832 oracle.exe

   CWD: C:\oracle\product\9.2.0\DATABASE\    CmdLine: c:\oracle\product\9.2.0\bin\ORACLE.EXE WIN92    VirtualSize: 234972 KB PeakVirtualSize: 248440 KB    WorkingSetSize:108600 KB PeakWorkingSetSize:108600 KB    NumberOfThreads: 13

   2836 Win32StartAddr:0x01978efc LastErr:0x00000000 State:Waiting
   2868 Win32StartAddr:0x77df3539 LastErr:0x0000007e State:Waiting
   2884 Win32StartAddr:0x006fec70 LastErr:0x000003e5 State:Waiting
   2536 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   2564 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   2568 Win32StartAddr:0x00430360 LastErr:0x000000b7 State:Waiting
   2576 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   2720 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   1316 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   2780 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   2828 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   2668 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
   1148 Win32StartAddr:0x00430360 LastErr:0x00000000 State:Waiting
 

If you don't have it, you can get the number of threads info out from task manager as well (go to view -> select columns and select "thread count").  

btw, if listener is having trouble spawning new threads (or processes in unix), it should be seen from listener log..  

Tanel.

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joey D'Antoni
Sent: 22 April 2009 23:31
To: Brian.Zelli_at_RoswellPark.org
Cc: oracle-l_at_freelists.org
Subject: Re: See processes in windows

Brian,  

If you go to sysinternals.com
http://technet.microsoft.com/en-us/sysinternals/cb56073f-62a3-4ed8-9dd6-40c8 4cb9e2f5.aspx one of the free tools-- process monitor or process explorer should show you what you want.  

The standard oracle processes (pmon, ckpt, et al.) are threads under the oracle.exe process in Windows.  

Good luck.  

Joey D'Antoni

---

From: "Zelli, Brian" <Brian.Zelli_at_RoswellPark.org> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, April 22, 2009 10:04:12 AM Subject: See processes in windows

Hello all,

   I can see oracle processes in unix but how do I see them in windows? We have some connection issues and I want to see how many pids are out there.  

ciao,
Brian  

 <mailto:brian.zelli_at_roswellpark.org>  

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 22 2009 - 10:59:21 CDT