Re: Oracle SGA size on i386 platforms

From: Dave <x_at_x.com>
Date: Thu, 07 Apr 2005 23:38:41 GMT
Message-ID: <5wj5e.6170$G8.986@text.news.blueyonder.co.uk>

"Tim X" <timx_at_spamto.devnul.com> wrote in message news:87ekdmxl4m.fsf_at_tiger.rapttech.com.au...
>
> Hi All,
>
> Just wondering if I can get some clarification on SGA size limits in
> Oracle 9i running on i386 based platforms (Windows and Linux). I've
> been told there is a 2Gb limit on both these platforms - though there
> does seem to be some workarounds under windows which will allow you to
> get to 3Gb.
>
> Can anyone confirm or refute this claim? We are planning to move from
> Tru64 to another platform, but one of our applications uses a 4Gb SGA
> (which we would like to increase even further). I've looked through
> some documentation, but haven't found a clear anser to this question.
>
> Also, if anyone knows of any 'gotchas' for Oracle running on Windows,
> I'd like to hear about them. We have no experience with Oracle on
> windows and would be interested in anything you may be able to
> contribute.
>
> Tim

there is a 1.75 gb limit on 32bit systems, without some fancy relinking on linux or playing with windows

no gotchas (hate that term) on windows, if you understand windows - will work well for you.

Why do you think you need a bigger than 4gb SGA? Received on Thu Apr 07 2005 - 18:38:41 CDT