| NEXT EXTENT size [message #163069] |
Tue, 14 March 2006 20:07  |
blundermaster
Messages: 1
Registered: March 2006
Location: Kuala Lumpur
|
Junior Member |
|
|
Hello Everyone,
Recently I have created an index with the following command
"create index <index_name> on <table_name> (col1,col2,col3,col4) tablespace <tablespacename>"
The index creation was completed successfully. Based on the dba_segments view the index has following attribute
EXTENTS = 13
INITIAL_EXTENT = 2097152
NEXT_EXTENT = 272121856
PCT_INCREASE = 50
The tablespace has the following attributes
INITIAL_EXTENT = 2097152
NEXT_EXTENT = 2097152
PCT_INCREASE = 50
My question, why the index's NEXT_EXTENT value did not follow tablespaces value. Since I didn't provide the storage parameter to the index it should followed the tablespace.
Can someone correct me on this? How does Oracle set the NEXT_EXTENT value to the index, is there any algorithm to determine the NEXT_EXTENT size?
Oracle verion = 7.3.4
rgds,
Ram.
[Updated on: Tue, 14 March 2006 20:10] Report message to a moderator |
|
|
|
| Re: NEXT EXTENT size [message #163335 is a reply to message #163069] |
Thu, 16 March 2006 05:32  |
 |
Alien
Messages: 292
Registered: June 1999
|
Senior Member |
|
|
Hi,
EXTENTS = 13
INITIAL_EXTENT = 2097152
NEXT_EXTENT = 272121856
PCT_INCREASE = 50
2097152*(1.5^12) = 272097792 (Including some rounding on the different extents).
Oracle followed your directions, and made every extent 1.5 times the previous one.
Regards,
Arian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
