Re: Simple Oracle Query Taking Too Long

Frank van Bortel wrote:
> DA Morgan schreef:
> >
> > That is about as horrible a definition as I can imagine. I can't think
> > of a single justification for either the 64K extents or a pctincrease
> > that is anything except 1.
> >
>
> And what would be wrong with 64kB extents?

Each one needs to be mapped in tables in the system tablespace for DMT.  With extreme growth, those tables have extent problems. Some people would even use unsupported methods to fix them, as opposed to recreating the db.

jg

-- 
@home.com is bogus.
http://www.obscurestore.com/