Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2008
    Posts
    6

    Unanswered: Which is better for an Oracle Database? 2 quad cores or 4 dual cores

    Good day,

    I just would like to ask which is better to have in a server that has a Oracle 10G database on it, 4 dual cores or 2 quad cores? Also together with the database in the machine are OWB and BIEE apps. Thank you

    Lan

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    which is better to have in a server
    Better for what? Performance? Reliability? Compatability? Future-proofing? (etc etc etc)
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jul 2008
    Posts
    6
    better for performance and reliability, because as of now we're having a long time running ETL on OWB and executing BIEE reports all at the same time.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by arjapzon
    Good day,

    I just would like to ask which is better to have in a server that has a Oracle 10G database on it, 4 dual cores or 2 quad cores? Also together with the database in the machine are OWB and BIEE apps. Thank you

    Lan
    What evidence do you have that the CPU is the limiting resource;
    as opposed to the disk subsystem?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2008
    Posts
    6
    as of now we still don't have any evidence of that, i just want to check out and compare the performance of having 2 quad cores vs. 4 dual cores.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >i just want to check out and compare the performance of having 2 quad cores vs. 4 dual cores.
    So please do not delay running your benchmark comparison tests & reporting your findings backhere.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jul 2008
    Posts
    6
    actually im not benchmarking here. I just want to know the best practice in the industry of deploying a 4 dual cores or 2 quad cores in a server on which it has an Oracle database on it. Does it clarify you already?

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You need to know how OWB and BIEE apps behave & interact, so specific benchmarks are required otherwise your results may vary.
    Do both CPUs run at same speed with same amount on on chip cache?
    Do both systems have the speed for processor bus?
    Do both systems utilize same memory architectures?
    Do both motherboards same I/O subsystem interfaces?

    How do separate the contribution of processor model to overall benchmark results
    from other components to determine which chip is "better" than the other?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You need to know how OWB and BIEE apps behave & interact, so specific benchmarks are required otherwise your results may vary.
    Do both CPUs run at same speed with same amount on on chip cache?
    Do both systems have the speed for processor bus?
    Do both systems utilize same memory architectures?
    Do both motherboards same I/O subsystem interfaces?

    How do separate the contribution of processor model to overall benchmark results
    from other components to determine which chip is "better" than the other?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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