Workflow Instance cause CPU over 50%

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 12
Joined: Sun 20 May 2012 04:25

Workflow Instance cause CPU over 50%

Post by EmilyFong » Mon 04 Feb 2013 04:36


I am using (version 6.80.350.0) in my workflow service (host in IIS) to connect to Oracle (11g R1).
I found that once I start a new workflow instance with my client application, the CPU in database server will up to 50 (for oracle.exe only). After 5 minutes or more, the CPU will be down again.
In Orcale session, I found the following statement run again and again.
:result :=
InstanceStoreLogic.LoadInstance (:p_surrogateLockOwnerId,

I tried to add a insert statement in LoadInstance function, and found that it only insert one record with the p_instanceid '00000000000000000000000000000000'.

I would like to know how can I trace this problem.


Best Regards,

Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow Instance cause CPU over 50%

Post by Shalex » Wed 06 Feb 2013 16:07

We have sent a test project to the e-mail you have specified when registering at our forum. Please modify the code and send it back to us so that we can reproduce the problem in our environment.

Post Reply