That's be 2K for block size so the figure would be 64K. If you have the
opportunity to change the block size it is likely that there is a more
appropriate one for your OS. Steve Adams has a good discussion about 'large'
block sizes at www.ixora.com.au
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"jarom" <jarom_at_xotmail.com> wrote in message
news:u5zF7.14$h3.106412_at_news.kpnqwest.ch...
> Thanks!
>
> I have a database with db_file_multiblock_read_count=32 and
> db_block_size=2048. Does this mean, I should not assign extents smaller
than
> 64MB (which seems quite large to me for some tables)?
>
>
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:1004960616.1581.0.nnrp-10.9e984b29_at_news.demon.co.uk...
> >
> > Start with the FAQ listed below.
> > Look for the word "extent" in the index page.
> >
> > --
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> >
> > Host to The Co-Operative Oracle Users' FAQ
> > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> >
> > Author of:
> > Practical Oracle 8i: Building Efficient Databases
> >
> > Screen saver or Life saver: http://www.ud.com
> > Use spare CPU to assist in cancer research.
> >
> > Jann wrote in message ...
> > >In Oracle documentation, I never found any practical hints on what
> criteria
> > >should be used to determine ideal extent sizes for tables and indexes
and
> > >how they impact database performance.
> > >
> > >Can anyone help me with this issue or have a clue where good relevant
> > >documentation can be found?
> > >
> > >Jann Romer
> > >
> > >
> >
> >
>
>
Received on Tue Nov 06 2001 - 03:19:12 CST
