Re: 3GB RAM usage by Oracle

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 24 Aug 2004 16:14:01 +1000
Message-ID: <412adca8$0$30602$afc38c87@news.optusnet.com.au>

DGK wrote:

> Thanks for all the replies.
>
> The application was having very bad response time. As a first step, I
> found that the RAM usage as follows:
>
> - Oracle: around 1.3GB
> - Other Windows processes around: 0.2GB
>
> So I was thinking rest of the RAM (1.5GB) is not being utilised. Hence I
> posted the question.
>
> Now I have tuned few of the SQL statements and found that response time
> has increased.

A good reply.

A good riposte, too, to some posts made in another thread where throwing hardware at a tuning problem is considered by some to be an efficient, effective and cheap way of tuning.

Thanks for the follow-up.

Regards
HJR Received on Tue Aug 24 2004 - 01:14:01 CDT