Re: Getting started with performance issues on Oracle for W2k3 ...
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.
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.
> Srinivas Chintamani