DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: High CPU usage for Oracle.exe

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    High CPU usage for Oracle.exe

    Platform: Oracle 8.1.7.3 on Windows 2000

    We have a production system that has been running ok for a year until last night, the CPU usage for Oracle.exe shot up close to 100% AND stayed there for at least 10 hours. I suppose the fact it stayed high for more than 10 hours rules out SMON was doing cleanups and coalesing. The temp tablespace is about 2GB. There is no code change since day one.

    Does anybody know any other situations that may have caused something like this?

    Thanks,

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    I came accross with same situation on Window 2000 after applying the patch but able to weed out after re-ran the catlog and catproc one more time.

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    when was the last time you booted the box?
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: High CPU usage for Oracle.exe

    Originally posted by a128
    Does anybody know any other situations that may have caused something like this?
    may be due to this ... Optimizer Bug
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

    Re: High CPU usage for Oracle.exe

    Originally posted by a128
    rules out SMON was doing cleanups and coalesing.
    cleanups of what?

    coalescing... dont you use LMT?!

Posting Permissions

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


Click Here to Expand Forum to Full Width