ADDITIONAL: Performance Problems DU 4.0b + Oracle 7.3.3

From: Gunther Feuereisen <gunther_at_ibm.net>
Date: Tue, 11 Nov 1997 11:22:28 +0800

I did some more investigating, and I found that the loopback interface lo0 was
generating all the network traffic (300 pkts each way), which could be hogging
the system CPU utilisation .

I failed over to my backup machine, and found that the problem seems to
have gone
away, my system CPU utilisation down to about 8% ..

I rebooted the original master machine, and the loopback problem seemed to
have stopped.

However, my loopback packets still average 5-10 .. which still seems a
little high?

Anyone have any suggestions asto why this could be happening?

tia (again)
gunther

--
My original message follows;
>Sender: alpha-osf-managers-relay_at_sws1.ctd.ornl.gov
>Followup-To: poster
>Date: Tue, 11 Nov 1997 12:40:19 +0800
>From: Gunther Feuereisen <gunther_at_ibm.net>
>Subject: Performance Problems DU 4.0b + Oracle 7.3.3
>X-Sender: gunther_at_pop03.ca.us.ibm.net
>To: alpha-osf-managers_at_ornl.gov
>X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.3 (32)
>
>Hi,
>
>We're currently working on development of a new system, and I've just noticed
>a performance problems; the CPU utilisation seems to be constantly around
>or over
>50% for system related requests ..
>
>What I have:
>
>2 x Alpha 4000's 5/300 512 MB RAM in a DECsafe configuration
>
>Local storage on each machine,  4 MB RAID 1 (2x rz29b on SWXCR)
>Shared storage, 3 x rz29b, each mirrored onto another drive on a second bus
>using LSM.
>i.e. rz17 <-> rz25, rz18 <-> rz26 and rz19 <-> rz27
>Disks are on BA35X shelves going to KZPSA's using DWZZB's
>
>I'm using AdvFS for fast crash recovery etc.
>
>On my shared storage, each LSM mirror is a separate fileset, in it's own
>filedomain.
>
>I am running Oracle 7.3.3
>
>I have looked at resource utilisation:
>
>approx 280 MB RAM is free
>swap has 80% free
>I/O across drives is sporadic, with bursts of up to 300 kbps (at the
>worst), but on
>average, bursts of about 30-60 kbps.
>volstat reports occaisional I/O consistent with the above.
>
>I've checked uerf/dia, and there are no errors etc.
>
>Tools I've used; iostat, vmstat, swapon, monitor, volstat, uerf
>
>And yet, performance is sluggy, with the system utilising a constant 50-60%
>CPU ..
>
>Anyone have ideas? I can't see it .. is it something obvious I am just not
>seeing?
>
>thanks in advance,
>gunther
>
>

Received on Tue Nov 11 1997 - 04:36:41 NZDT