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 Fri Apr 30 1999 - 22:14:04 CDT
