Home » RDBMS Server » Server Administration » 100% processor usage
100% processor usage [message #61000] Thu, 18 March 2004 07:54
Tibor
Messages: 2
Registered: March 2004
Junior Member
Hi,

I try to resolve following problem with 9.2.0. client. Until now we use Oracle client 8.1.7 in IIS/ASP application - we use Oracle OLE DB Provider. But we develop new applications on .NET platform and so we upgrade Oracle client from 8.1.7 to 9.2.0 version. This upgrade bring to us big problem because the processor usage is 100% and count of processed requests decreases to 10% of count processed with 8.1.7 client. We apply last pach from Oracle but it is same.

For resolve of this problem I develope small application where I create 2 transactions, in first I insert and update one record and in second I delete this record. I test this application with Microsoft Application Test Center and during 5 minutes simultaneously 20 clients generate approximately 10 requests per second. With client 8.1.7 all is OK. But on 9.2.0 client processor go to 100% time. After finish of test processor keeps 100% usage yet.

Can you advise to me where the problem is?

Thank you
Previous Topic: How to work out free space in segment extent?
Next Topic: moving ORACLE_HOME
Goto Forum:
  


Current Time: Tue Jan 07 23:20:38 CST 2025