Re: create_index_cost procedure
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Jul 2009 05:57:46 +0100
Allocated Bytes = 1,735,000,064 = 13,237 extents @ 128KB
Allocated Bytes = 1,736,441,856 = 828 extents @ 2MB
Allocated Bytes = 1,740,636,160 = 166 extents @ 10MB
Allocated Bytes = 1,782,579,200 = 34 extents @ 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@xxxxxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>; <oracle-l-bounce@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
