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

Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting statistics speeds up server?

Re: Deleting statistics speeds up server?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 29 Oct 2003 22:27:02 GMT
Message-ID: <W8Xnb.2414$Ub4.2030@twister.socal.rr.com>


Tom Dyess wrote:

> One of our clients is running Oracle 9.2.0 on AIX. Our application that runs
> on oracle was dog slow on their box. They brought in a consultant in and he
> deleted the statistics on the tables and indexes and it sped it back up
> again. Doubting the remedy, our net admin, reanalyzed the tables and it was
> slow again, then deleted statistics and it was again fast. Does anyone know
> what would cause such an unintuitive response?
>
> Tom Dyess
> OraclePower.com

Incorrect optimizer settings would certainly do it. I'd start with, what analysis went into setting OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING?

--
Richard Kuhler
Received on Wed Oct 29 2003 - 16:27:02 CST

Original text of this message

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