[HPADM] SUMMARY: strange system bottleneck during Oracle 7.3.4 startup on HPUX 10.20 K580

From: Ted.Fisher@dana.com
Date: Thu Jun 26 2003 - 11:00:14 EDT


Before I vent I'd like to thank Rita Workman who was the only person to send me a real reply. She suggested looking at
Oracle patch levels which I will pursue.

Unfortunately this list has apparently deteriorated from the helpful
technical resource it once was because two out of three responses I
received came from hardware vendors hoping to get some business. Responses
like the one below are not helpful or desired! The only affect it will
have is that I will NEVER buy hardware from them for having abused a
resource that was once helpful to those looking to pool technical knowledge. It is unfortunate that a few individuals can disrupt the
value of this list and don't realize that they are hurting - not helping -
any chance that we might buy from them. I'll not use the list any more
unless I have a dire emergency because it's not worth putting up with the
headache. Sorry for ranting.

Thanks again to Rita.

Ted F. Fisher
Dana Corporation
Global Information Technology Group
Technical Team
Ted.Fisher@dana.com

Sounds to me as if the bottleneck is in the CPU and/or memory, which
appears to be affecting your I/O performance. The best way to figure it
out is trial and error.
 
What I can do is send you additional CPU('s) and memory for a 30 day trial period. If this solves your problem, the
items can be purchased at an outstanding price.
 
If you are interested, please contact me so we can discuss your current
configuration and get you set up.

Regards,
Stephan Oakes
Shore Consulting
5 Gajewski Lane
Cedar Run, NJ 08092
(609) 978-3700 (609) 978-3784 Fax
steveo@shoreconsult.com
AOL IM Soakes88
www.shoreconsult.com
----- Original Message -----
From: Ted.Fisher@dana.com
To: hpux-admin@dutchworks.nl
Sent: Wednesday, June 25, 2003 4:32 PM
Subject: [HPADM] strange system bottleneck during Oracle 7.3.4 startup on HPUX
10.20 K580

List,
        We have a K580 running HPUX 10.20 and two Oracle 7.3.4 SIDs. When
the second SID is started it appears to hang the entire system. Until the
second SID is up the first is completely frozen (user sessions), glance
will not start or update if already running, etc. The load average climbs
to over 12 while the DB is starting and drops once it's up. Top will run
and shows the CPU very low which would indicate that the high load value
is due to IO. Sar shows disk queues pretty low though (=< .50). I can
log in a new session with no problem. The behavior of the system is
similar to when a disk dies and IO's get hung causing any IO related
process to hang. But, I can't find what kind of IO is hanging or why. We
have other similar systems which don't appear to have this problem. Has
anyone seen this kind of behavior before or have any suggestions as to how
t! o identify the bottleneck?

I will summarize.

Thanks.

Ted F. Fisher
Dana Corporation
Global Information Technology Group
Technical Team
Ted.Fisher@dana.com

--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)


This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:30 EDT