ORA-02393: exceeded call limit on CPU usage

ORA-02393: exceeded call limit on CPU usage

Postby 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
arox5
 
Posts: 2
Joined: Thu 14 Apr 2011 14:31

Postby 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.
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44

Postby 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)?
arox5
 
Posts: 2
Joined: Thu 14 Apr 2011 14:31

Postby 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.
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle