Re: Solaris and Oracle 8.0.5 Problems 100% CPU utilization.

From: Alexander Pastuhov <alexp_at_cssl.com_REMOVE_>
Date: Thu, 06 May 1999 21:10:06 +1000
Message-ID: <3731788E.40CC@cssl.com_REMOVE_>

Interesting. Our customer has a very similar problem with 7.3.3 on IBM AIX. I'm going to see them tomorrow...

Alexander Pastuhov
Senior Technical Consultant
CSSL Australia, Melbourne
(041 936 3524)

Chris Krebs wrote:
>
> We are running an E6500, 6GB ram, and 10 CPUs
> Oracle 8.0.5, Veritas, with quickio turned off.
>
> This is a high volume OLTP database with JDBC connections
> to handle the web traffic and VB/ODBC processes to
> update the database (don't ask about the vb processes, it was not my
> idea)
> .
> The problem seems to occur when the VB processes try
> to open up 180 or so connections at the same time.
> The CPU pegs to 100 % and no new connections can be established.
> Existing connections can still execute queries, but the vb processes
> start sucking cpu and no new connections can be established. The box
> frees up when the oracle server side processes for the VB app are
> killed.
> This seems to happen when the box is busy, and the VB app and it's
> 180 connections starts to fire up.
> has anyone seen this 100% cpu behavior.
> tia
> chris
Received on Thu May 06 1999 - 06:10:06 CDT