| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Re: A transaction profile question - block growth always groups of 5?
> From memory, the old 5 block trick was an Oracle 7 thing... but it also
> takes place in Oracle 8 (and presumably 8i) UNLESS you specify a MINIMUM
> EXTENT clause for the tablespace. If that's specified, then the increment
> is in MINIMUM EXTENT-sized chunks. If it's not, then it's the *table's*
> NEXT clause, rounding up to the nearest 5.
Let me disagree. There is no compulsory rounding up to the nearest 5. The extent could be 1 block in size (no min extent size of course). Yes, it can get up to 4 blocks more than you requested. _If_ the free space is fragmented in such a way Oracle couldn't find anything better.
Igor.
 |
 |