Re: Deleting statistics speeds up server?

In response to your questions --

The migration that usually takes 4 hours to run took 20, GUI tasks took significantly (multiples) longer - all select queries at that point minus comparitavely miniscule internal application auditing.

We usually build the Oracle box for the clients running Win2k and we do the install, set the tuning params and everything. It's always worked fine. We have a few unix clients but we require them to do the install since we don't support unix. Other unix clients run fine as well. This particular one doesn't. We set our parameters the same on their oracle instance as well with SGA adjustments under proportionate to the extra memory they have (4x more than we require), but more than our "official" parameters. Do you think a small SHM_MAX setting in the kernel would cause that?

"Tom Dyess" <tdyess_at_dysr.com> wrote in message news:fvudnfSkNonIuD2iRVn-jw_at_fdn.com...
> 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
>
>
Received on Fri Oct 31 2003 - 15:09:37 CST