Re: Memory usage of ORACLE 8i service

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/04/14
Message-ID: <390ea463.24506358@netnews.worldnet.att.net>#1/1

You might start by looking at the following parameters in your database init file:

	shared_pool_size
	java_pool_size
	db_block_buffers

The first two are in bytes. To translate the last one into bytes, multiply by the db_block_size value. You can reduce the values for these parameters. They affect performance, but if you're the only user, you probably don't need a very large shared pool or buffer cache. The settings I use for one of my small test databases are:

shared_pool_size = 3500000 # INITIAL
java_pool_size = 4000000
db_block_buffers = 1000

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Fri, 14 Apr 2000 15:33:40 GMT, skiefer_at_pikon.com (Sascha Kiefer) wrote:

>Hi,
>
>after I installed Oracle 8i on my PC with 512 MB RAM, about 440 MB are
>used by Oracle.
>How can I force the database just to use about 250 MB ?
>
>Thanks,
>Sascha
>----------------------------------------------------------
> Sascha Kiefer
> PIKON International Consulting Group GmbH
> http: www.pikon.com E-Mail: skiefer_at_pikon.com
> Tel: +49-681-37962-0 Fax: +49-681-37962-90
>----------------------------------------------------------
Received on Fri Apr 14 2000 - 00:00:00 CDT