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 profile assigned to the user.
B.
Modify the roles assigned to the users.
C.
Modify the object privileges assigned to the user.
D.
Modify the system privileges assigned to the users.
E.
Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
Reason for ORA-02392: exceeded session limit on CPU usage, you are being logged off
Cause: An attempt was made to exceed the maximum CPU usage allowed by the CPU_PER_SESSION clause of the user profile.
Action: ask the database administrator to increase the CPU_PER_SESSION limit of the user profile.