Re: Q: Perfromance problems on AIX

From: <michael_bialik_at_my-deja.com>
Date: Mon, 10 Jan 2000 20:49:54 GMT
Message-ID: <85dglb$noa$1@nnrp1.deja.com>

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. Received on Mon Jan 10 2000 - 14:49:54 CST