Results 1 to 4 of 4

Thread: Cpu 100%

  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: Cpu 100%

    Oracle8.0.5 On NT 4.0 . 10~20 Online User , Heavy batch running scheduled .

    The CPU sometime peak at 100% when the batch is running .
    User complain the speed ( ANd they thought the server is dead :-) .

    How do you think , Which way should I enter to tune the database in this case
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Aug 2002
    Posts
    3
    Similar setup and problem. However, I have about 120 users in the system. The CPU will stay at 100%, and won't drop. Only resolution is to re-boot the server. Any help is greatly appreciated.

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You could always work with a database sever that can handle multiple users...
    rws

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Usually if you get 100% CPU it is usually to many concurrent transactions. It can also occur if the CPU is spinning waiting to get access to resources i.e. contention.

    You really need to look at what the batch process is doing and then try out different solutions until you hit the right one. If you dont have access to the source code for the batch job look at the v$sqlarea (do a flush shared_pool just before the batch job) or switch on tracing ( though this will slow things down a lot potentially). You may need to optimize the database but more likely it will be the way the batch process works i.e. it might be doing lots of small transactions which it might be possible to aggregate into fewer but larger transactions.

    Apologies for being vague but without more info on what the batch job is doing and the configuration of the database it is difficult to advise.

    Alan

Posting Permissions

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