CPU requirment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: CPU requirment

  1. #1
    Join Date
    Sep 2001
    Posts
    3

    Exclamation CPU requirment

    Does CPU performance has great impact of Oracle 9i performance?
    I am evaluating two machines. One is P4, 3.2 GHz with 1 GB RAM. The other one in P4, 2.26 Ghz with 512 M RAM. How can I show that the first one is better than the other in using Oracle?

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    All things equal, you shouldn't have to ride a bike to tell that a Honda CBR 1100 will outperform a CBR600 on the tracks anyday.

    PS : Okay, sarc apart - M1 has more memory and horsepower than M2. It's a nobrainer. If you wanna 'take it to the tracks' - run stress tests.

  3. #3
    Join Date
    Sep 2001
    Posts
    3
    I can't do any test, because I don't have the machines. We are planning to buy one of them. Of course, I want to buy M1, but my boss would ask me "why". Therefore, I would like to know the impact of CPU in using Oracle.

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    Is this a high school project or something?

  5. #5
    Join Date
    Sep 2001
    Posts
    3
    Isthere any difference between celeron CPU and P4 CPU?

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Allison

    Oracle runs faster on P4 as well as quake runs faster on p4..:-)

    regards
    Hrishy

  7. #7
    Join Date
    Mar 2002
    Posts
    534
    That totaly depends what your are doing on your DB. But a "server" with 1 GB of RAM will certainly be a better choice then one with only 512MB.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    Re: CPU requirment

    Originally posted by alisonhui
    Does CPU performance has great impact of Oracle 9i performance?
    In a properly tuned OLTP system, you would not see much difference in a 2.4Ghz and a 3.2 Ghz box. Most likely your biggest bottleneck will be I/O throughput. In a poorly tuned system, yes, CPU speed does matter.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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