Re: Locally Managed Tablespaces ... again!!!

Charlie Edwards wrote:

> Oracle 8.1.7.2
>
> Well, on my last project I finally convinced my DBA to try LMTs. So
> he knows about them.
>
> I get transferred to another project and, lo-and-behold, we're back to
> Dictionary Managed Tablespaces (sigh), with tables and indexes in
> separate tablespaces (double sigh).
>
> He says theres no advantage to LMTs as long as you ensure that your
> PCTINCREASE is 0 and your extents are always <4 blocks * (a power of
> 2)> - i.e. 4, blocks, 8 blocks, 16 blocks, 32 blocks etc. His logic
> is that in this case any space freed up will always be available for
> use and so you won't have any fragmentation.
>
> I'd be grateful for any comments as I'm starting to get more than a
> bit frustrated.
>
> TIA,
>
> CE

Your DBA needs to be taken out behind the woodshed and introduced to the concept of continuing education.

Try the following SQL if you can.

SELECT initial_extent, next_extent, pct_increase, COUNT(*) FROM dba_tables
GROUP BY initial_extent, next_extent, pct_increase;

Worst case run it against ALL_TABLES.

And see how well he/she is doing.

Daniel Morgan Received on Fri Jan 10 2003 - 11:16:05 CST