Re: Size of Extents?

Your answers and links brought some clarity into that isssue - thanks to all!

Jann

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3be7ab5c$0$8514$ed9e5944_at_reading.news.pipex.net...
> 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 Wed Nov 07 2001 - 09:48:28 CST