Oracle/AIX strange behavior
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