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

On May 12, 4:26 pm, gst <groups.spamt...@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

sorry, sentence broken: "java".... can be disabled, i don't use it.

On May 12, 9:26*am, gst <groups.spamt...@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

On May 12, 5:37 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
> 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

Thanks David,
I'll try to put my boss into hardware-shopping-spree-mode; maybe this
would be the shortest route to an usable development platform

On 16 Maijs, 11:03, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:
> 1GB laptop would default to 700MB for Oracle. Why aim for 32MB?!?
> about 100M is workable, and even allows for some options.
> I have been working 512MB~1GB XP laptops with the database, Designer
> and iAS (pl/sql) running. Nothing to be jealous about, but more
> workable than my current 4GB Vista (yuck!)

I worked with XE on my ancient laptop with 256 RAM, ~700MHz. SGA was
140M, for syntax checking and some tests it was quite ok, even created
tables with a few million rows and count(*) worked
Don't remember probably Oracle something sceptical said upon
install

Gints Plivna
http://www.gplivna.eu

On May 20, 11:59*am, Gints Plivna <gints.pli...@gmail.com> wrote:
> On 16 Maijs, 11:03, Frank van Bortel <frank.van.bor...@gmail.com>
> wrote:
>
> > 1GB laptop would default to 700MB for Oracle. Why aim for 32MB?!?
> > about 100M is workable, and even allows for some options.
> > I have been working 512MB~1GB XP laptops with the database, Designer
> > and iAS (pl/sql) running. Nothing to be jealous about, but more
> > workable than my current 4GB Vista (yuck!)
>
> I worked with XE on my ancient laptop with 256 RAM, ~700MHz. SGA was
> 140M, for syntax checking and some tests it was quite ok, even created
> tables with a few million rows and count(*) worked
> Don't remember probably Oracle something sceptical said upon
> install
>
> Gints Plivnahttp://www.gplivna.eu

Now that you mention it, my work XP PC has 1G, crappy old full disks
and runs XE fine, as long as I don't leave it in archivelogmode and
fill the crappy old disks the rest of the way up. Stupid adobe and
word docs take so much room...

But I do all my serious work on the servers.

jg
--
@home.com is bogus. “If the act can effectively eliminate the real-
child requirement when a proposal relates to extant material, a class
of protected speech will disappear.” David Souter, dissenting from
opinion that says you can be convicted of child pornography crimes
even if there is no pornography at all. So "the child pornography is
here..." oops! This post is a crime! You're a child molester now!
Have fun in prison!