Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Oracle Query Taking Too Long

Re: Simple Oracle Query Taking Too Long

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 09 Sep 2006 11:26:41 +0200
Message-ID: <edu12k$1rm$2@news6.zwoll1.ov.home.nl>


joel garry schreef:
> 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

Ah - yes, and altering sql.bsq to change storage clauses...
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Sep 09 2006 - 04:26:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US