Re: create_index_cost procedure
- From: <genegurevich@xxxxxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Mon, 6 Jul 2009 10:44:27 -0500
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?
thank you
Gene Gurevich
Phone 224-405-4079
Database Engineering and Operations
Enterprise Data Management (EDM)
Discover Financial Services
"Jonathan Lewis"
<jonathan@jlcomp.
demon.co.uk> To
Sent by: <oracle-l@xxxxxxxxxxxxx>
oracle-l-bounce@f cc
reelists.org
Subject
Re: create_index_cost procedure
07/02/2009 04:17
PM
Please respond to
jonathan@xxxxxxxx
emon.co.uk
Answers here.
http://jonathanlewis.wordpress.com/2009/05/22/index-size/
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: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, July 02, 2009 7:55 PM
Subject: create_index_cost procedure
> Hello everybody:
>
> I am using create_index_cost procedure (oracle 10.2.0.3) to estimate the
> size of a future index and find an appropriate tablespace parameters for
> it.
> Here is my code:
>
--
//www.freelists.org/webpage/oracle-l
Please consider the environment before printing this email.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
