Re: LOCALLY MANAGED EXTENT PERFORMANCE
- From: Arul Ramachandran <contactarul@xxxxxxxxx>
- To: Ibrahim.Dogan@xxxxxxxxx
- Date: Sat, 23 Apr 2005 14:50:39 -0700
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@xxxxxxxxx> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
