Page 1 of 1

ORA-02393: exceeded call limit on CPU usage

Posted: Thu 14 Apr 2011 14:48
by arox5
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

Posted: Fri 15 Apr 2011 14:04
by Shalex
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.

Posted: Mon 18 Apr 2011 07:25
by arox5
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)?

Posted: Thu 21 Apr 2011 14:41
by Shalex
We cannot reproduce the problem at the moment. We will investigate the issue and notify you about the results as soon as possible.