Re: Memory usage (newbie)

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 17 Jun 2002 19:37:56 GMT
Message-ID: <3D0E3A86.8F596E39@exesolutions.com>

"John M." wrote:

> Hi,
>
> I want to test my application with an oracle database. I have installed an
> Oracle 8i server to my computer and I wanto to use it only on local PC. But
> my system use about 400Mb RAM. Is it possible to decrease it?
>
> Thanks!
> John

If you are saying that Oracle is using 400MB RAM you have definitely grabbed far more memory than is necessary. I run 8i, easily, in 64MB RAM using the following initSID.ora parameters.

db_block_buffers = 2048
shared_pool_size=7680000
java_pool_size=65536 (and it could be 32K) log_buffers=32768
sort_area_size=65536

Daniel Morgan Received on Mon Jun 17 2002 - 14:37:56 CDT