RE: See processes in windows
Date: Wed, 22 Apr 2009 23:59:21 +0800
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..
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
Subject: Re: See processes in windows
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.
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
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.
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.Received on Wed Apr 22 2009 - 10:59:21 CDT