Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORACLE 10g Performance: Dual-core versus Many-core

644807Sep 15 2009 — edited Sep 20 2009

All

I am not absolutely sure if this is the right place to ask this question, but generally what is the recommended hardware approach with regards to running ORACLE Data Warehouse on a multi-CPU system with options of either: dual-core or many-core(4, 6 or 8 cores)?

My understanding suggests that a server based on an eight-core processor does not offer the same performance benefits of eight single-core processors; so logically it would be better to keep the cores to a minimum while still using the 'parallelism' feature of ORACLE on a multi-core system. Is this a correct assumption? Or can you squeeze out that bit of added performance by utilizing a single count of a many-core processor?

Examples of an 8-core system:

Option1: HP DL580 G5 Server, 4 * Intel Xeon E7220 Dual-core processors 2.93 GHz, RAM 32GB DIMMs
Option2: Sun SPARC T5440 Server, 1 * T5440 8-core CPU module 1.4 Ghz 64 threads, RAM 32GB DIMMs
Option3: HP DL785 G5 Server, 2 * AMD Opteron 8393 Quad-core processors 3.1 GHz, RAM 32GB DIMMs

Which option would be the most optimum one?

Cheers,
F

Edited by: OracleDisciple on Sep 16, 2009 12:03 AM

This post has been answered by 108476 on Sep 15 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2009

Added on Sep 15 2009

#general-database-discussions

11 comments

3,211 views