Comment below
Regards
HJR
--
------------------------------------------
Oracle Resources: http://www.hjrdba.com
============================
"michael ngong" <mngong_at_yahoo.com> wrote in message
news:ecf365d5.0201300830.ceab8dd_at_posting.google.com...
> "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.
"But for the most part it is advisable to make your block size equal to OS
blocksize"
You are kidding, right? According to you, a db_block_size of 512 bytes is
just fine and dandy?
You either work with a very mysterious operating system that has block sizes
of 8K and up, or you meant to type the words 'a multiple of' instead of
'equal to'.
If you were being serious and not making a typo, however, then (I regret to
say) your advice is a pile of poo.
Regards
HJR
> Michael Ngong Tubuo(Sr DBA)
Received on Wed Jan 30 2002 - 13:12:09 CST
