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

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:t24e5usip4n88alim8l2gvj16dj6f3ndtc_at_4ax.com...

> 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

 yap, thx! Received on Wed Jan 30 2002 - 11:55:29 CST