Re: Oracle On AIX : Urgent Help Required

I heard a rummour there was a problem wirt AIX, Oracle and mirroring and was looking for more evidence of this probelem. It looks to me that you have the same problem.

If i know more i will let you know.

Wil

Weterings_at_schiphol.nl

Guyver wrote in message <7vt3ou$4ot$1_at_nclient13-gui.server.virgin.net>...
>Pick up the latest version of monitor, of use something like sar -p ALL
>(check parms!?) to see all CPU perf.
>
>janjua <janjua_at_cableinet.co.uk> wrote in message
>news:381C0C1C.3D529B90_at_cableinet.co.uk...
>> Hi All
>>
>> We have serious problems on an AIX box regarding Oracle Database.
>>
>> We have an AIX RS 6000 High Node machine with AIX 4.2.2 4 CPU's ,
>> 1 GB of Ram and 16 Mirrored hard Drives of 4GB each. Total of 32
>>
>> The database is 7.3.2 Oracle database with an SGA of 250 MB.
>>
>> We are running an in house developed application. The response is
>> very
>> bad. We have 80 users using the machine.
>>
>> We have tuned the database to the best of our abilities but the
>> users are
>> getting a very bad response.
>>
>> The machine and database is never taken down.
>> After nearly every two Weeks we come to a situation where database
>> virtually comes to halt and we have to either bounce the database or
>> reboot
>> the system.
>>
>> We have same application running on a SUN box with lesser BOX specs
>> and
>> don't have any problems.
>>
>> We have pretty good in house Oracle Expertise.
>> We don't have much AIX expertise in house.
>>
>>
>> Please if you could think of any thing on the Operating system/
>> Hardware
>> side which could be causing this Problem .
>>
>> Any thoughts / pointers will be highly appreciated.
>>
>> We have a doubt that the AIX is not using all 4 Processes and that may
>> be
>> causing this problem.
>>
>> Any commands to check if all 4 processes are being used or if there is
>> a
>> memory leak.
>>
>>
>> Thanking you in advance for emailing the replies
>>
>> Bye
>> Aamer
>>
>> Aamer_janjua_at_hotmail.com
>>
>>
>
>
Received on Sat Nov 06 1999 - 13:00:06 CET