Re: How much RAM is to much
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: RStorey@xxxxxxxxxxxxxxxxxx
- Date: Thu, 10 Feb 2011 13:18:28 -0600
I generally use the rule of thumb for Linux/unix of oracle can have up to
80% of the RAM on the system on a dedicated server. However, make sure
everything on the OS is configured per the installation instructions for
oracle before you start dedicating all those resources to oracle.
On Thu, Feb 10, 2011 at 1:02 PM, Storey, Robert (DCSO) <
RStorey@xxxxxxxxxxxxxxxxxx> wrote:
> So, I’m moving my 9i 32 bit database to a 10g 64 bit database. My 9i box
> has 4 gig of ram and the usual 23bit limitations. My SGA and such on the 9i
> box probably hovers around 1.2gig.
>
>
>
> I have 24 gig of ram on the new box. From a data aspect, that will darn
> near load my entire database to memory.
>
>
>
> So, in setting SGA_TARGET, how much is too much? Before I was told the box
> specs, I was thinking 3 gig. But, with 24 gig available, and I’m the ONLY
> application on the box….how much is to much?
>
>
>
> What are the benefits and cons to setting this value at say, 12gig, with a
> SGA_MAX value of 15G.
>
>
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
