Re: Re: A transaction profile question - block growth always groups of 5?

Igor: read your books. I didn't just invent this stuff.

HJR <61.12.128.6 [Igor Laletin]> wrote in message news:9cthq18pfc_at_news2.newsguy.com...
> > 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.
>
>
>
> ==================================
> Poster's IP address: 61.12.128.6
> Posted via http://nodevice.com
> Linux Programmer's Site
Received on Fri May 04 2001 - 09:14:46 CDT