If you are using IIS 6 or later I would check there first. I have run into a similar problem where IIS said that any Oracle connection was a memory leak and it would start hogging memory without releasing it. I remember correctly I set a limit to the amount of memory it could suck up before releasing it automatically and solved the problem.
Cheers John Scoles Srinivas Chintamani wrote:
Hi All,I am running into getting timeouts from an ASP.net web app that connects to an oracle database on W2k3. I am kind of lost on where to START to identify what is causing these problems. In general when an oracle db starts going slow, is there some kind of a check-list that I can use to zero-in on what is causing the problem.Reading through the Oracle manuals gave me a head-ache, since the amount of material to go through is really massive. If anybody knows of any resources to this end (short and sweet), I would very much appreciate, if you can share it with me.-- Regards,Srinivas Chintamani
-- //www.freelists.org/webpage/oracle-l