Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting statistics speeds up server?
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 KuhlerReceived on Wed Oct 29 2003 - 16:27:02 CST