Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOCALLY MANAGED EXTENT PERFORMANCE
Do not use uniform sized LMTs for volatile tables since you may end up having a table/index with thousand of extents..
More important, don't blame LMTs for it..=20
If you use AUTO extent allocation instead of uniform size, you won't have problem...
Thanks,
=20
Ibrahim DOGAN
Sr. Sybase/Oracle DBA
www.lowes.com
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org=20
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson=20
> Larry - lwolfs
> Sent: Saturday, April 23, 2005 12:24 AM
> Cc: oracle-l_at_freelists.org
> Subject: LOCALLY MANAGED EXTENT PERFORMANCE
>=20 >=20
>=20> time to do truncates.
> Recently I noticed one of my applications taking a long=20
>=20> huge tables took 2 hours and 7 minutes to do a truncate on=20
> I once had a purchased app using a 16K extent size for=20
>=20
> Thanks
> Larry
>=20
>=20 >=20> The information contained in this communication is=20
> **********************************************************************
>=20
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 23 2005 - 00:52:46 CDT