Re: Getting started with performance issues on Oracle for W2k3 ...

  • From: John Scoles <scoles@xxxxxxxxxxx>
  • To: srinivas.chintamani@xxxxxxxxx
  • Date: Wed, 23 Apr 2008 09:28:48 -0400

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


Other related posts: