product logo Competitive Analysis: IBM DB2 UDB
Most significant differences between Oracle Database and IBM DB2 UDB, in the arena of performance and scalability.
Oracle Database
Concurrency Model

Multi-version read consistency

Non-Escalating row-level locking


Locks escalate

Clustered configurations
Transparent scalability with Real Application Clusters
Rigid data partitioning required with DB2 EEE
Indexing capabilities

Wide variety of indexing schemes

Only B-Tree and dynamic bitmap indexes

Partitioning options
Range, hash, list and composite partitioning

Local and global indexes

Only hash partitioning

Only local indexes

Additional data warehousing capabilities
Multi-table INSERT
Not supported
Intelligent advisories
Access, SQL Tuning, Index, Summary, Memory, MTTR Index advisory only
Self-tuning capabilities

Automatic Performance Diagnosis

Automatic SQL Tuning

Self-tuning memory, free space, and I/O management

No equivalent or limited capabilities

For a more detailed comparison, see " Technical Comparison of Oracle Database vs. IBM DB2 UDB: Focus on Performance", an Oracle White Paper, May 2005

Back to Database Performance Page