Re: how 2 size memory params in int.ora?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 29 Jan 2002 22:15:59 +0100
Message-ID: <t24e5usip4n88alim8l2gvj16dj6f3ndtc@4ax.com>

On Tue, 29 Jan 2002 19:40:17 +0100, "Steffen Ramlow" <s.ramlow_at_gmx.de> wrote:

>when i have a 1 CPU host with 0.5 - 1GB RAM and ora 8.1
>it should be optimzed for select queries
>
>tia
>

The Oracle guideline is the SGA should not exceed one third of physical memory. For the rest: there are only 'rules of thumb' (db_block_buffers * db_block_size usually starting at 40M and shared_pool_size should start at 40-60M). The major factor, however, is whether your developers actually optimized their statements and are using bind variables.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jan 29 2002 - 15:15:59 CST