ORA-02393: exceeded call limit on CPU usage

arox5 · 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 · 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 · 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 · 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.