RESOURCE LIMIT

[big]

Hi,
On 11.2.0.4 en AIX ,
we have

RESOURCE_NAME                    LIMIT                                  
-------------------------------- ----------------------------------------
                                     
CPU_PER_SESSION                  UNLIMITED                              
CPU_PER_CALL                     UNLIMITED

Is UNLIMITED  for CPU inconvenient for performance?

How to find good value?

Thank you.

[ErmanArslansOracleBlog]

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..)