Re: How much RAM is to much
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: RStorey@xxxxxxxxxxxxxxxxxx
- Date: Mon, 14 Feb 2011 19:23:08 +0530
Robert,
somewhere 15 gb comes to 60%+ of your total 24Gb of memory, I think it is
comfortable value one..default installation of oracle takes 60-80% of total
memory available..
and if you are sure that your database can work well with present values
(i.e. 3gig and 500 mb or may be some plus increment to it..) then how about
exploring times ten database..
http://en.wikipedia.org/wiki/TimesTen
thanks..subodh
On 14 February 2011 18:55, Storey, Robert (DCSO) <RStorey@xxxxxxxxxxxxxxxxxx
> wrote:
> well, the database is the only thing running on the box, so there are no
> others to estimate. With regards to the PGA and SGA, I’ve got my PGA on
> automatic and it runs at about 500 megs, with the SGA pushin about another
> 800megs.
>
>
>
> So, I’m contemplating about 1 gig for PGA and about 3 gig for SGA. The, do
> a lot of AWR work and such to see how it is doing stats wise, and watch the
> users feedback.
>
>
>
> *From:* Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
> *Sent:* Sunday, February 13, 2011 2:02 PM
> *To:* Storey, Robert (DCSO)
> *Cc:* oracle-l-freelists
> *Subject:* Re: How much RAM is to much
>
>
>
> Robert,
>
>
>
> can you try to estimate how much memory you can utilise for other things?
>
> I'd try to provide as much PGA for all your processes to avoid any temp
> segments. (this is not that easy as it sounds right now)
>
> Maybe this limits the max possible SGA for you.
>
>
>
> best regards,
>
> Martin
>
> On Thu, Feb 10, 2011 at 20:02, 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.
>
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
