ORA-02393: exceeded call limit on CPU usage

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
arox5
Posts: 2
Joined: Thu 14 Apr 2011 14:31

ORA-02393: exceeded call limit on CPU usage

Post by arox5 » Thu 14 Apr 2011 14:48

Hello,
we are using the last dotConnect for Oracle.

We execute a query using a database user with limited IO resources.
If this query fails with error "ORA-02393: exceeded call limit on CPU usage" we get the error if directMode is set to False. If directMode is set to True we don't get the error and the execution ends with the CommandTimeOut (if the CommandTimeOut is not set the query doesn't end and the connection remains locked/used).

The Oracle version is Oracle9i Enterprise Edition Release 9.2.0.6.0.

Thank you,
Andrea

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 15 Apr 2011 14:04

Please specify the exact version (x.xx.xxx) and edition of your dotConnect for Oracle. You can find it in the Tools > Oracle > About menu of Visual Studio.

I cannot reproduce the problem with dotConnect for Oracle v 6.10.135 at the moment: both OCI (via Oracle Client) and Direct modes generate the "ORA-02393: exceeded call limit on CPU usage" error in my environment.

arox5
Posts: 2
Joined: Thu 14 Apr 2011 14:31

Post by arox5 » Mon 18 Apr 2011 07:25

We are using dotConnect for Oracle version 6.10.135.0.

The problem can be that our DBA are using, to limit the CPU usage, the Oracle Database Resource Management (DRM)?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 21 Apr 2011 14:41

We cannot reproduce the problem at the moment. We will investigate the issue and notify you about the results as soon as possible.

Post Reply