Re: RESOURCE LIMIT

Posted by ErmanArslansOracleBlog on May 09, 2022; 3:23pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RESOURCE-LIMIT-tp10887p10896.html

These are documented things, Big.

CPU_PER_SESSION  
Specify the CPU time limit for a session, expressed in hundredth of seconds.

CPU_PER_CALL  
Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.

There is no good values for these.. It depends on your environment.

Note that, we don't set these resource through profiles.. We use Database Resource Manager for these types of tasks.. And we use I/O Resource Manager for the I/O Subsystem.. (if we are on an Exadata of course..)