RE: Locally Managed Tablespace Uniform Extent

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 03 Apr 2001 14:05:43 -0700
Message-ID: <F001.002E0849.20010403140652@fatcity.com>

> -----Original Message-----
> From: Miller, Jay [mailto:JayMiller_at_TDWaterhouse.com]
>
> My understanding was that the main reason to keep the number
> of extents down
> was in case you needed to drop or truncate the table it would
> take Oracle a
> long time to clean up the fet$ table.
> I think, and I emphasize that I am not certain of this, that
> this is no
> longer a problem with locally managed tablespaces.
> I'm sure someone will correct me if I'm wrong...

As usual, Steve Adams has some sage advice on the subject. Check out his article "Planning Extents" http://www.ixora.com.au (click on Tips then on Planning Extents) in which he mentions that there are reasons for keeping the number of extents down even in a locally managed tablespace. Received on Tue Apr 03 2001 - 16:05:43 CDT