Re: Next extent with Locally managed tablespace on 9i

In article <3D4E792B.8EBAA4DC_at_oracle.com>, you said (and I quote):

> <p>The assumption with all this of course is the 500ish extent limit. There
> is still some debate regarding what an appropriate limit really is with
> regard to LMT. All the Oracle doco discusses having many 1,000s of extents

Quite right. And even the 500 thing is relative. If you're the "Dirk the Daring" type and have modified the sql.bsq in the listed spots, you'll find that with DMT the limit for bad performance is around 1000, sometimes higher depending on what changes and what block size.

I'd expect LMT would be at least a coupla thousand if not more. Or even much more. Dunno. I know one thing: I blew a PL/SQL loop last year and an LMT TS went into overdrive at around 3000 extents. Performance went out the window. That was 8.1.7.0. Ie, no patches.

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam