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

You ceratinly can use Oracle in win2k with 256mb ram, and get reasonable response from the demo database.

If the machine is a personal workstation then I'd suggest that you want to do the following

1. Oracle database service and oracle listener set to MANUAL startup.
2. check the init.ora parameters for your database. You probably don't want a 20mb java pool, or a particularly large shared pool 1 or 2mb will be plenty. keep the buffer pool down to a reasonable size , say 30m or so.
3. don't run dba studio or oem. learn how to use sql*plus/svrmgr

If you connect as sysdba then you can issue the command show sga which will tell you how the memory allocation is made up.

In addition you could always invest 20 quid or so in another 256mb of ram. This has two advantages.

1. Oracle will be happier - as would sql server or any other RDBMS
2. Baldurs Gate loads much faster and you can justify the expense to your partner as 'work-related'

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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

>

>