Re: create_index_cost procedure
Date: Mon, 6 Jul 2009 10:44:27 -0500
Message-ID: <OF961F2E43.C046BB2C-ON862575EB.005647B9-862575EB.00567AC4_at_discover.com>
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_at_jlcomp.
demon.co.uk> To
Sent by: <oracle-l_at_freelists.org>
oracle-l-bounce_at_f cc
reelists.org
Subject
Re: create_index_cost procedure
07/02/2009 04:17
PM
Please respond to
jonathan_at_jlcomp.d
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_at_discover.com> To: <oracle-l_at_freelists.org> 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:
>
-- http://www.freelists.org/webpage/oracle-l Please consider the environment before printing this email. -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 06 2009 - 10:44:27 CDT