Re: Examining the space allocation within individual Extents

Jimbo1 wrote:

> Creating locally managed tablespaces is not currently an option we wish
> to investigate, as we just don't trust them in 8i. New Oracle features
> are notorious for being a tad, how can I put this, buggy. It's hard to
> be sure with my lack of knowledge being as it is, but I seem to
> remember LMT's being a new feature in 8i.......

Used to be true ... not much so since 9.2.0.4. But my experience with LMT at 8.1.7.4 was that they were a huge improvement.

> After upgrading to 10g R2, LMT's will be looked at more seriously as an
> option.

Option? Hardly. ;-) They will be mandatory.

> For someone who's never even seen the app I'm working on, you seem to
> presume an awful lot about it, but maybe that's just my perception of
> things.
>
> Cheers.
>
> James

I presume some things. But some other things are just the nature of physics. LMTs are faster and solve many of the problems of dictionary managed tablespaces. Among those problems solved are the ones you indicate you are dealing with.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)