Re: Size of Extents?

From: jarom <jarom_at_xotmail.com>
Date: Mon, 05 Nov 2001 16:27:06 GMT
Message-ID: <u5zF7.14$h3.106412@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 Mon Nov 05 2001 - 10:27:06 CST