Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: db_block_buffers = 3200?

Re: db_block_buffers = 3200?

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Tue, 29 Jan 2002 16:11:32 -0000
Message-ID: <a36hdp$et8$1@thorium.cix.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US