Re: How to reduce memory consumption?

From: Frank van Bortel <>
Date: Fri, 21 Mar 2008 19:42:45 +0100
Message-ID: <3ac95$47e401a6$524b5c40$>

gnewsgroup wrote:
> I am new to Oracle.
> I just installed Oracle11g enterprise edition on my Windows XP Sp2
> system. My computer is a Pentium 4, 2.20GHz with 1G memory.
> If the Oracle service is running, it consumes around 400M memory, and
> as a result, my computer becomes barely usable.
> I only need to practice / play with Oracle 11g, so I am wondering if
> it is possible to greatly reduce its memory consumption and yet still
> let me play with it happily.
> Thank you.

When you created the database instance, did you pay any attention to the screen where the memory distribution was listed?

You could try to start the Database Creation Assistant again, and see if you can change those parameters.

Alternatively, close some of the programs you are running; 1GB of RAM, with 40% allegedly for Oracle, leaves 600MB for XP, that only uses about 200, when installed conservatively.
The 400MB is used somewhere else - find it!


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Fri Mar 21 2008 - 13:42:45 CDT

Original text of this message