Re: create_index_cost procedure

From: Jonathan Lewis <>
Date: Mon, 6 Jul 2009 21:44:43 +0100
Message-ID: <AC0FB175595B446E91CF9F77B1BEA354_at_Primary>

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.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ

  • Original Message ----- From: <> To: <> Cc: <>; <> 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?

Received on Mon Jul 06 2009 - 15:44:43 CDT

Original text of this message