Re: calculating next extent

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 6 Sep 1999 12:42:52 +0200
Message-ID: <7r05so$mn$1@oceanite.cybercable.fr>

corky711_at_my-deja.com a écrit dans le message <7r00ps$bro$1_at_nnrp1.deja.com>...
>dear sirs 'n ma'ams,
>
>1. How exactly does oracle calculate the size of the next extent it
>will allocate in a segment? formula?

When Oracle allocates a new extent it calculates the "next next": new NEXT = old NEXT * (1+PCTINCREASE/100) this value is rounded up to the next multiple of 5 blocks.

>2. I also see segments not following the next_extents value set for
>that segment...instead it follows the next_extent value specified for
>the tablespace's default...why's that happen?
>

May be the parameters NEXT and PCTINCREASE were not given at the creation of the table and the table have been altered after with the parameters NEXT and/or PCTINCREASE you see now.

>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Sep 06 1999 - 05:42:52 CDT