Re: db_block_buffers = 3200?

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Tue, 29 Jan 2002 17:06:12 +0100
Message-ID: <a36h53$15s1hr$1@ID-54600.news.dfncis.de>

"Alistair" <alistair.thomson_at_sphinxcst.co.uk> wrote in message news:a36g6j$e5j$1_at_thorium.cix.co.uk...
> Hi
>
> 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.

should always be os cluster size?

>
> 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 - 10:06:12 CST