HELP , major perfomance probs!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: HELP , major perfomance probs!!!

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Unhappy

    4 days ago the application which runs against my ora 7.2 db(on Novell , why me) started to crawl. Nothing in the alrt log cpu sometimes hangs at 100% but users even report the prob when its bouncin between 5% and 30%
    im checking for missing indexes, but I ran and explain plan on a sql statement that one of the develpoers was using(that i know was making the cpu run at 100%) and it was ez and like 6 lines of explain plan with no full table scans. Any immediate help would be GREATLY appreciated!!!

    Thanks in advance,
    SM

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Call in the hardware people to look at the unix. could be control card, raid or cpu itself or memory management. Which box is it? hp or sun? look at syslog too.
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Could it be you are simply swapping (paging)? Have you or anyone recently changed something in the init.ora?

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