Database Error Messages

ORA-02390

Exceeded COMPOSITE_LIMIT. Session is being logged off.

Cause

The COMPOSITE_LIMIT for the profile is being exceeded. That is, the weighted sum of the connection time, logical reads per session, CPU usage per session, and private system global area (SGA) space used during the session exceeded the limit set by the COMPOSITE_LIMIT clause set in the user profile.


Action

Change the SQL operation so that it does not exceed the COMPOSITE_LIMIT. Or, if the COMPOSITE_LIMIT is too low, ask the database administrator to raise the COMPOSITE_LIMIT of the user profile, or determine the resource that is used the most and raise the limit on that resource.