Re: LMT Autoallocate initial, tot # of extents

Hi Barbara,
This is to be expected.

Your experience here bears out what is found at http://www.freelists.org/archives/oracle-l/06-2004/msg01925.html and a few other places.

Extent size will start out as 1m, progress to 8m and then 64m.

Setting 'INITIAL' will not affect the size of the extents IIRC, just the number of them.

Since you alread know the size of the table, perhaps a uniform extent size tablespace would be more practical.

Jared

On 6/6/05, Barbara Baker <barb.baker_at_gmail.com> wrote:
>
> Oracle 9.2.0.4 <http://9.2.0.4> Solaris 9 Blocksize 8192
>
> I'm attempting to move (alter table .. move tablespace) several
> tables from DMT to autoallocate LMT for a database migrated from
> 8.1.7.4 <http://8.1.7.4> to 9.2.0.4 <http://9.2.0.4>. (Agonized over
> autoallocate vs. uniform size.=20
> Perhaps I made the wrong choice.) Anyhow . . .
>
> ...
> Switches to 8192k after 64 extents
>
> FORXML_BCK 63 1048576 =
> =20
> FORXML_BCK 64 8388608 =
> =20
> FORXML_BCK 65 8388608 =
> =20
>
> Switches to 65,536k after 184 extents
>
> FORXML_BCK 183 8388608 =
> =20
> FORXML_BCK 184 67108864 =
> =20
> FORXML_BCK 185 67108864 =
> =20
>
> --------------
> Bytes Ext Init Next Min
> Meg nts Ext Meg Ext Meg Exts
> ------------ -------- ---- -------- -------- ----
> FORXML_BCK
> ADVLMT 2,752 211 64 1
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l