Re: db_block_buffers = 3200?

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Tue, 29 Jan 2002 15:50:39 -0000
Message-ID: <a36g6j$e5j$1@thorium.cix.co.uk>

Ignore the small, medium and large titles - they are meaningless these days. I would recommend that you increase the size of db_block_buffers to 25600 (50Mb) and tune it from there.

By the way your database will work better if you create it with a 4k blocksize.

Alistair

"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message news:a369sd$15v1rr$1_at_ID-54600.news.dfncis.de...
> in my ora 8.1 initora file this is marked as "LARGE"
> block-size is 2048
>
> 3200x2048 bytes - this is LARGE????
>
> p.s. i have 600 MB RAM for NT 4 + Ora 8.1
>
>
Received on Tue Jan 29 2002 - 09:50:39 CST