Re: "desperately tiny" rdbms setup

On May 12, 9:26 am, gst <groups.spamt..._at_gmail.com> wrote:
> Hi everyone,
>
> i would like to try to install an oracle rdbms (possibly XE) on a
> machine which is also the main development environment and is _way_
> "low spec" (1gig, laptop). it runs win xp (unfortunately).
>
> thus i would like to setup an "extremely lilliputian" version.
> everything from 8i to 11g/xe should be ok; is it feasible to squeeze
> the sga under 32mb? reading the docs i got the impression that it's
> practically impossible but... i dare to ask. java
>
> do you have some urls (howtos, etc.) handy that could be useful?
>
> thank you in advance
> gst

For 10.2.0.3 the fixed size of the SGA is 2 MB; squeezing your buffer cache, redo buffers and various pools into 30 MB is, I think, asking the impossible. You MAY be able to get a database to start, and run (with glacial speed) with a 32 MB SGA but I can't expect it to be of much use to anyone who might want to actually do something productive.

David Fitzjarrell Received on Mon May 12 2008 - 10:37:11 CDT