Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> oo4o and IIS
We're developing an application in asp with oracle at the back. It does
connections with oo4o using a pool. All sql are in pl/sql packages.
With little load it works great, but when putting some load on the app,
after some time connections between web server and db stop responding
generating an error on "CreateSql". This error happens as many times as
there are connections to Oracle. After that following pages breaks on
GetDatabaseFromPool.
When this have occurred all pages that uses a db connection fails, but pages without connections executes fine. The db keeps responding as usual after the failure, e.g. it accepts connections from other applications.
There are no errors in alert.log nor listener.log
The tests uses 50 connections at the same time, the pool accepts 100.
During the tests dllhost.exe memory consumption fluctuates between 250-350MB, the server uses in total less than 600MB (of 1GB).
Open cursors during test are a little less than 3000, more or less constant.
To me it seems that some resource in the Oracle client software runs out, but I can't seem to understand what.
Client is 10.1.0.3 on win 2000, DB is 10.1.0.3 on Linux.
Any ideas on how to debug this further greatly appreciated! Lex Received on Thu Jun 09 2005 - 14:31:32 CDT