Oracle/AIX strange behavior

From: Fernando Nantes <nantes_at_itanet.com.br>
Date: 1996/09/23
Message-ID: <01bba968$9431b880$23e8f5c8_at_Nantes.itanet.com.br>#1/1


Hi,

I have the following configuration

Machine A:

        IBM RS/6000 370H, 256 MB RAM, AIX 3.2.5, Oracle 7.1.4, 10 MB SGA

Machine B:

        IBM RS/6000 J30, 4 CPU, 512 MB RAM AIX 4.1.4, Oracle 7.1.6, 100 MB SGA

Machine C:

        IBM RS/6000 370H, 256 MB RAM, AIX 4.1.4, Oracle 7.1.6, 10 MB SGA

Machine A runs a Payment application that is basically a loop that calculates the
salary for each employee. There is a *commit* for employee.

When we run the same application in machine B or machine C we have a progressive
performance degradation. For 400 employees it starts spending 30 secs/employee and
terminates with 6 minutes/employee. It doesn't happen with machine A.

Every machine has exactly the same data.

Any ideas?

Thanks in advance

Fernando Nantes (nantes_at_itanet.com.br) Received on Mon Sep 23 1996 - 00:00:00 CEST

Original text of this message