Re: Memory in Windows---is 256Mb RAM enough for Win2k?

I would suggest 256Mb as a minimum realistic amount (though I earnestly hope such a database wouldn't be hitting production any time soon). Be warned that the default memory sizes Oracle adopts are, er... shall we say aggressive?- in the extreme.

For example, Java Pool Size defaults to 20Mb. So even if you have a saints intentions in hell of using Java, there's a large dollop of memory gone for a start. The seed databases created by the Database Configuration Assistant tend (from memory) to assume you are going to be using Intermedia and Spatial, too.

For the record, I had an 8.1.7 database chugging along acceptably (for testing purposes) on NT4 Server on a Pentium 166MHz with just 160Mb of RAM. If I recall correctly, my shared_pool_size was 5M, and my db_block_buffers was 60. It can be done, but it's not pretty

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"news.shef.ac.uk" <@.> wrote in message
news:9qjoup$5it$1_at_hermes.shef.ac.uk...


> I recently had Oracle 8 EE on my PC but discovered after installation that

> it was using virtually all of the available RAM even when I started up the

> machine.  Thus, any Java applications running on top were starved of

memory.


>

> My question is, what is the "realistic" minimum RAM on Win2k that is

> feasible?

>

> Mike

>

>