Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db_block_buffers = 3200?
True - default is 4k
"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 - 10:11:32 CST