Re: Q: Perfromance problems on AIX

Hallo again,

jobrien99_at_my-deja.com schrieb:

> Also run Analyze on the tables.

Do you mean, to use a cost based optimizer? I think, i should first try to find the leak either in the base or with the server.

> Run sar 5 100 and observe the wio on both machines.

OK. But what it means there is a heavy WIO on the system. I does not have any experiences with tuning OS or either
analyzing performances of OS. Usually a high number means a problem, but how high ist normal?

> In article <85dglb$noa$1_at_nnrp1.deja.com>,
> michael_bialik_at_my-deja.com wrote:
> > Hi.
> >
> > Try comparing EXPLAIN on test vs. prod machines.
> > If no differences found -
> > use ALTER SESSION SET SQL_TRACE = TRUE;
> > to trace what actually happens in prod. ( May be you are
> > using incorrect access and have very small number of rows in test ).

I does not like to tune the application in this situation. I have a problem with

different machines, the nearly the same data bases on both of ist. And the cruix is, the application on the slower machine is much faster (up to two times faster)
then on the faster machine.

Thanks for hints.

Yours sincerely,
Waldemar Schlonsok Received on Wed Jan 12 2000 - 09:10:58 CST