Re: create_index_cost procedure

Allocated Bytes = 1,735,000,064 = 13,237 extents _at_ 128KB 
Allocated Bytes = 1,736,441,856 =    828 extents _at_ 2MB
Allocated Bytes = 1,740,636,160 =    166 extents _at_ 10MB
Allocated Bytes = 1,782,579,200 =     34 extents _at_ 50MB

Notice that the change from one figure to the next is less than the larger of the two extent sizes. Note also that each figure is an exact multiple of the extent size.

Oracle is rounding up to allow for the unused portion of the last extent.

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 11:26 PM Subject: Re: create_index_cost procedure

> Jonathan:
>
> Here is my output :
>
> Allocated Bytes = 1740636160
>
> Allocated Bytes = 1735000064
>
> Allocated Bytes = 1736441856
>
> Allocated Bytes = 1782579200
>
> TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT
> LOGGING ALLOCATIO EXTENT_MAN
> ------------------------------ ---------- -------------- -----------
> --------- --------- ----------
> USERS 16384 131072 131072
> LOGGING UNIFORM LOCAL
> PCM_D_03 16384 2097152 2097152
> LOGGING UNIFORM LOCAL
> UNICA_X_01 16384 10485760 10485760
> LOGGING UNIFORM LOCAL
> UNICA_D_01 16384 52428800 52428800
> LOGGING UNIFORM LOCAL
>
> thank you
>

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