Re: create_index_cost procedure
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 6 Jul 2009 21:44:43 +0100
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@xxxxxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>; <oracle-l-bounce@xxxxxxxxxxxxx>
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
