Re: Oracle/AIX strange behavior

varad acharya <vacharya.ford_at_e-mail.com> wrote in article <324971C1.692F_at_e-mail.com>...
> Fernando Nantes wrote:
> > > Fernando Nantes (nantes_at_itanet.com.br)
>
>
> What else is running on machine B & machine C ?

Nothing else

> It is possible that other stuff running on these machines contibute
> to the degradation of Oracle performance.
>
>
> --
>
> Regards,
>
> Varad Acharya
>
The original message was:

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)

PS: There isn't any others apps running concurrently. Received on Thu Sep 26 1996 - 00:00:00 CEST