What action would you take to increase the CPU usage limit in the subsequent sessions of the user?

A user complains about getting this error after issuing a certain SQL statement:
ORA-02393: exceeded call limit on CPU usage
Because of the error, the SQL statement gets aborted. What action would you take to increase the CPU usage limit in the subsequent sessions of the user?

A user complains about getting this error after issuing a certain SQL statement:
ORA-02393: exceeded call limit on CPU usage
Because of the error, the SQL statement gets aborted. What action would you take to increase the CPU usage limit in the subsequent sessions of the user?

A.
Set the RESOURCE_LIMIT initialization parameter to FALSE.

B.
Modify the resource limit in the profile used by the user.

C.
Increase the value of the SESSION_CACHED_CURSORS initialization parameter.

D.
Increase the value of the SESSION_MAX_OPEN_FILES initialization parameter.



Leave a Reply 0

Your email address will not be published. Required fields are marked *