Re: LOCALLY MANAGED EXTENT PERFORMANCE

Hi Ibrahim,

I also dumped LMT/Uniform allocation, and moved to LMT/Autoallocate.

On that 27G table, what is the largest size of an extent? I don't think it goes beyond 64M ( I am fine with that :). What is the version of Oracle?

Thanks,
Arul

On 4/22/05, Dogan, Ibrahim - Ibrahim <Ibrahim.Dogan_at_lowes.com> wrote:
>=20
> Even with LMTs, you still wory about number of extents whenever you run
> any command that performs extent allocation/deallocation (create
> table/rebuild index/truncate table etc..)
>=20
> My point was that I saw many people going back to DMT because of very
> same issue you're experiencing with LMTs.. When LMT with uniform extent
> size is used, you need to babysit the segments to make sure they don't
> go beyong couple thousand extents.. But you don't have this problem if
> you use LMT with AUTO extent allocation. My biggest table is 27G in a
> AUTO LMT and it has around 600 extents..
>=20
> I generally prefer AUTO LMT and reorg the tables after bulk deletes...=3D=
20
>=20
> Thanks,
> =3D20
> Ibrahim DOGAN
> Sr. Sybase/Oracle DBA
> www.lowes.com
>

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