Which action would you take to increase the session limit on CPU usage?

A user complains that he gets the following error message repeatedly after executing some
SQL statements. The error message forces the user to log off from and log on to the

database to continue his work. ORA-02392: exceeded session limit on CPU usage, you are
being logged off Which action would you take to increase the session limit on CPU usage?

A user complains that he gets the following error message repeatedly after executing some
SQL statements. The error message forces the user to log off from and log on to the

database to continue his work. ORA-02392: exceeded session limit on CPU usage, you are
being logged off Which action would you take to increase the session limit on CPU usage?

A.
Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

B.
Modify the profile assigned to the user.

C.
Modify the roles assigned to the users.

D.
Modify the object privileges assigned to the user.

E.
Modify the system privileges assigned to the users.



Leave a Reply 0

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