Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02393: exceeded call limit on CPU usage -- Concept Understanding is req

947991Sep 11 2012 — edited Sep 11 2012

In our System CPU_PER_CALL is set to 1.5 Hours for Reporting Users.

I can see some query runs for 10 hours-15 hours and complete successfully and some queries fail exactly after 1.5 hours.

I want to understand what does CPU_PER_CALL Means. On what basis it calculates CPU_PER_CALL ( Fetch , Execute , parse). How a query is calculating time ?

With the same profile options some queries run for 10 hours but some queries fail after 1.5 hours.

Regards
Sourabh Gupta

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2012

Added on Sep 11 2012

#general-database-discussions

2 comments

7,444 views