ier to debug, but in some cases it may also be necessary to get a kernel dump to confirm the exact cause. The OS or Hardware vendor should be consulted for assistance in obtaining a kernel dump.
In order to take an adplus dump of the oracle.exe process, at a high level, you must install the 'Debugging Tools for Windows' and then run adplus as such:
adplus -hang -p
Be sure to use the correct PID corresponding to the correct oracle.exe. If you are running an ASM instance, you will most likely have at least two oracle.exe processes, but you will most likely want to run adplus and dump the oracle.exe associated with the database instance, NOT the ASM instance
For a complete description of what adplus is and how to run it, please refer to the following Microsoft Support note.
http://support.microsoft.com/kb/286350/en-us
@ For the issue described in the alert, the Adplus dumps of the oracle process may show threads
?
@ kiswapcontext
?
@ As noted above, in some cases, it may be necessary to take a
?
Workaround
The cause of this problem may be the following Microsoft bug, which is described in the following links:
http://support.microsoft.com/kb/919341
http://support.microsoft.com/kb/922658
?
This issue is known to be a problem in Windows 2003 with Service Pack 1, and can affect any application with large memory requirements, including single-instance Oracle database, Oracle RAC Databases and non-Oracle databases. It is strongly advised that this Windows hotfix be installed proactively on all Oracle installations running on Windows 2003 with Service Pack 1, or that those installations be upgraded to Service Pack 2 proactively.
Patches
Microsoft has a hotfix available on top of Service Pack 1, and the issue should also be resolved by upgrading to Service Pack 2. As noted above, see the following referenced Microsoft article for information on this fix:
http://support.microsoft.com/kb/919341/en-us
?
?