Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Cpu Session Exceeded

    ora-02392 exceeded session limit on cpu usage ,you are being logged off.
    This error message is detected only 2 times in the alert log file.
    Here defaul profile has cpu_session .. has unlimited and 2 other profile has
    30000.Is This a warning Message?



    So please tell me what should be the appropriate action?

    Thanks
    sudheer

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You need to find out the usernames for the sessions that are exceeding the limit. Then see which profile is being used by those users - it sounds as though it's the profile/s limiting the cpu usage. If you don't want the limit to be applied, then use the default profile for those 2 users.

    One of the benefits of using profiles is that it allows the DBA to 'share out' the resources more effectively amongst the users (e.g. to stop some users hogging the cpu), which is why the limit was probably put in place for the 2 users you mentioned.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •