Re: Oracle SGA size on i386 platforms

Hi!

Yes, you can go >4Gb SGA
Look: Physical Address Extensions (PAE) ja Address Windowing Extensions (AWE) teknik
Use at leats 9.2.0.4 f.ex with W2K.
We do not use it, but according information from Oracle it is OK.

Jack

"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
>
> --
> Tim Cross
> The e-mail address on this message is FALSE (obviously!). My real e-mail
> is
> to a company in Australia called rapttech and my login is tcross - if you
> really need to send mail, you should be able to work it out!
Received on Mon Apr 11 2005 - 06:19:02 CDT