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

Thread: High CPU Usage

  1. #1
    Join Date
    Jul 2001
    Posts
    40

    Question

    Hi,

    One of my server is having high cpu usage problem?

    Is there any checklist and v$views to check so that I can go through that accordingly and tune this CPU usage bottleneck.

    Please help me


  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Look at long table scans. Without the proper indexes Oracle will do a full table scan. The enterprise tuning tools are good at finding bad sql hitting a db.

  3. #3
    Join Date
    Jul 2001
    Posts
    40
    Hi,

    Thanks, Is there anyother thing to check?


  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Do a search about statspack. It replaced estat/bstat. Once you run the script to create the perfstat schema, then run a second ecript to schedule the job to take samples. You can have it run at specific intervals like every hour. There is a report that you can run which will tell you what you want to know about the database. High CPU utilization can be cause by many things. Running out of physical memory will cause page faults which will cause the CPU to stay busy. There are numerous other causes for this as well.

    how much physical memory does your server have? How much memory is allocated? What is the size of the swap file? How many users does your system have? What is the sort area size in the init file? How many disk sorts are occuring compared with in memory sorts? The list goes on.

  5. #5
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by alagy
    Hi,

    Thanks, Is there anyother thing to check?

    Check for the queries that use hash joints... and.. are you using MTS by any chance???
    -nagarjuna

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