Re: Please Help DB Buffer Cache Size

From: Jack <none_at_INVALIDmail.com>
Date: Wed, 17 Aug 2005 05:53:28 GMT
Message-ID: <shAMe.40$x21.25@read3.inet.fi>

<brijeshmathew_at_gmail.com> wrote in message news:1124168816.789941.299680_at_g14g2000cwa.googlegroups.com...
> Hi Everyone
>
> I am using Oracle 9i, Rel 9.0.1, running on Windows 2000 Server. Server
> is HP Proliant, with 1 GB Memory.

Perhaps you could allocate about max 500Mb RAM for SGA, and look what application/users says.
Assuming you have only one application/server on that server. Take somekind of metrics before and after changes to check if it is better (or worse).
Well, it looks like you have unused RAM (wasted money), so take them into use.
Your Oracle version is bit old -> upgrade 9iR2 if suitable. Received on Wed Aug 17 2005 - 00:53:28 CDT