Re: create_index_cost procedure

Didn't change at all, or didn't change much ?

How about posting the output from one dbms_xplan, and a list of extent sizes with allocated sizes.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- From: <genegurevich_at_discover.com> To: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org>; <oracle-l-bounce_at_freelists.org> Sent: Monday, July 06, 2009 4:44 PM Subject: Re: create_index_cost procedure

> Johathan,
>
> Thank you for your article. I am still unclear though why in my example the
> value of allocated parameter did not change
> even though I have specified different tablespaces with varying next_Extent
> values (from 128K to 50M). All these
> tablespaces a local with uniform extent value. I expected the allocated
> value to differ based on the size of an extent.
> IS that incorrect?
>

--
http://www.freelists.org/webpage/oracle-l