Re: Q: Perfromance problems on AIX

Also run Analyze on the tables.

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

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 ).
>
> Post the results.
>
> HTH. Michael.
>
> In article <85asb8$pc6$1_at_newsread.f.de.uu.net>,
> "Waldemar Schlonsok" <Waldemar.Schlonsok_at_knuut.de> wrote:
> > Hallo All,
> >
> > there are two machines both with AIX 4.2 and Oracle 7.3.4.
> > The second one is our test machine. On the test machine
> > which is much slower then the first, i got in a very important
> > process a performance of 3.500 up to 5.000 DML-operations
> > (i.e. insert update, delete). On the first one which is our
> > production machine, i got only the half. The problem is probably
> > the write I/O, but how to analyse the leak??
> > Who can help?
> >
> > Yours sincerely,
> > Waldemar Schlonsok
> >
> > Waldemar.Schlonsok_at_knuut.de
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 11:05:33 CST