Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db_block_buffers = 3200?
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<a37547$c75$1_at_knossos.btinternet.com>...
> 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
> > > >
> > > >
> > >
> > >
> >
> >
Many things come into play when tuning a database.The load it will
have to take the amount of cpu available,memory,the number of users,
the typical transactions that will take place etc
But for the most part it is advisable to make your block size equal to
OS blocksize and make the memory used by your db about 25% of the
total memory so in your case about 150M.These are not written in stone
though.
Michael Ngong Tubuo(Sr DBA)
Received on Wed Jan 30 2002 - 10:30:12 CST