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

From: John Scoles <scoles_at_pythian.com>
Date: Wed, 23 Apr 2008 09:28:48 -0400
Message-ID: <480F3990.8060603@pythian.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 23 2008 - 08:28:48 CDT

Original text of this message