Home -> Usenet -> comp.databases.oracle -> Impact of changed index inital extent

Impact of changed index inital extent

From: Rogbaker <Rogbaker_at_gdi.net>
Date: 16 Apr 2003 07:19:45 -0700
Message-ID: <e40a12ea.0304160619.3b67ca97_at_posting.google.com> 






In my database I have an index that had an INITIAL extent of
409,600,000 and a NEXT extent of 5,554,176 but only occupied 1 extent
due to the extreme size of the inital extent. I was able to alter both
the INITAL and NEXT extent to 256K but I had to increase the max
number of extents.  I was suprised that Oracle let me do this, I
thought I could only change the next, or is that just for tables not
indexes. It now has 957 extents instead of only one. Is there any
detremental effect from doing this?


Thanks for comments,


Roger
Received on Wed Apr 16 2003 - 16:19:45 CEST












Original text of this message