DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows w3wp.exe taking 100% CPU in Oracle client calls

144555Apr 22 2007 — edited Apr 26 2007

I have a Windows program running under IIS that makes ODBC calls with the Oracle 10.1.0.2 client drivers (the db server is on a remote system). Occasionally the application hangs at 100% CPU (actually the w3wp.exe application pool process in IIS) during a db call. A look at a hang dump gives me this in all the hung processes:

0679e3ac 612a1833 ORANLS10!lmsapsc+0x6c
0679e5e0 612a176e ORANLS10!lmsagbcmt+0x103
0679e614 612a1722 ORANLS10!lmsagbcmt+0x3e
0679e640 02b290f4 ORANLS10!lmsagbf+0x22
0679e658 0cf30bcf oci!lmsagbf+0x24
0679e684 0cf08e94 sqora32!SQLTablesW+0x372df
0679e71c 0cf08a90 sqora32!SQLTablesW+0xf5a4
0679e74c 0cef42ea sqora32!SQLTablesW+0xf1a0
0679e788 48892d59 sqora32!SQLDriverConnectW+0x17a
0679e7c8 48892b06 odbc32!SQLInternalDriverConnectW+0x221
0679ef24 488c1988 odbc32!SQLDriverConnectW+0xa8e
0679ef5c 0495d07c odbc32!SQLDriverConnect+0x125

Any ideas or information would be appreciated. I have reproduced this on multiple systems (which happen to all be multi-cpu).
Thanks,
Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2007

Added on Apr 22 2007

#odbc, #windows-and-net

1 comment

4,314 views