On block size. The last word on this is pretty much available at
www.ixora.com.au which is the site of the consulting company steve adams
works for. Check out the article entitled why a large db block size.
"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message
news:a36h53$15s1hr$1_at_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 - 15:44:39 CST
