 Performance & Scalability
For over three
decades, Oracle's Database technology has led the industry in
performance and scalability. Oracle Databases power a majority of the
world's most demanding environments and continue to build an
all-around lead across various industry standard benchmarks. Oracle
Database 11g extends this lead even further by
introducing capabilities that fully leverage the latest hardware
innovations to help customers meet the unprecedented demands being
placed on their IT infrastructure. Read on to know more about the
latest Oracle Database performance and scalability features, learn
expert tuning methodologies, and review competitive information. |
|
|
 |
| Tuning
Oracle Database often seems like an art rather than a science with so
many myths and folklores going around. However, in view of all the
innovative automation that has been introduced in Oracle Database over
the last few years, performance tuning does not have to be magic
science anymore. Take a look at the 2
Day + Performance Tuning Guide which introduces a structured
performance tuning methodology that can help you manage your database
performance proactively as well as help you detect and fix performance
problems quickly. |
|
|
|
| Oracle participates in several key industry
standard benchmarks to validate the performance and scalabilty of
Oracle Database. The Transaction Processing Council (TPC)
organizes benchmarks for both decision support (DSS) and online
transaction processing (OLTP) workloads. The DSS benchmarks are further
segmented based on the size of the underlying database. In addition to
TPC, Oracle participates in SAP benchmarks to assess the
performance of Oracle Database using Enterprise Software. Below are the
highlights of our leadership in these industry standard benchmarks. |
Oracle
Benchmark Leadership
| Benchmark |
World
Record Leadership |
| TPC-C
Clustered |
Oracle |
| TPC-C
Price/Performance |
Oracle |
| TPC-H
@ 3,000 GB Non-Clustered |
Oracle |
| TPC-H
@ 10,000 GB Non-Clustered |
Oracle |
| TPC-H
@ 10,000 GB Price/Performance |
Oracle |
| TPC-H
@ 30,000 GB |
Oracle |
| SAP
Sales and Distribution Parallel |
Oracle |
|
As
of June 24, 2008:
Source: TPC, www.tpc.org.
Details
Source: SAP, www.sap.com/benchmark.The SAP
SD-Parallel Standard Application Benchmark performed on November 26,
2007 by IBM in Beaverton, OR, USA has been certified with the following
data: 37,040 SAP SD-Parallel Benchmark users, 1.86 seconds average
dialog response time, 3,749,000 fully processed order line items per
hour, 11,247,000 dialog steps per hour, 187,450 SAPS. Server
configuration: IBM System p 570, 8 processors/16 cores/32 threads,
POWER6, 4.7 GHz, 128 KB L1 cache and 4 MB L2 cache per core, 32 MB L3
cache per processor, 128 GM main memory, running AIX 5L version 5.3,
Oracle 10g Real Application Clusters and SAP ERP 6.0. Certification
Number 2008013. |
| more |
Oracle
Performance in the News
|
 |
Oracle®
Database 11g Sets New World Record For
Price/Performance with TPC-C Benchmark |
|
Oracle Achieves
World Record Result on the SAP® SD-Parallel Standard
Application Benchmark |
|
Oracle®
Database 11g Sets World Record TPC-H 10 Terabyte
Non-Clustered Benchmark Result on HP Integrity Superdome Server and HP
StorageWorks Arrays |
| more |
Leader
in Real-World Scalability
|
|
| Oracle is the leading database for decision
support (DSS) and online transaction processing (OLTP) in real-world
customer environments, according to the 2005 WinterCorp
TopTen Program survey. The survey, which identifies the
world's largest and most heavily used databases, found that the largest
commercial data warehouse in the world runs a 100 terabyte (TB) Oracle
database. That's more than triple the size of the largest database in
the previous TopTen Program survey, which was also powered by Oracle.
The survey's newest category covering Linux DSS and OLTP databases was
completely dominated by Oracle customers. Overall, the survey found
that Oracle is the only database vendor whose customers posted top
results on Linux, Unix, and Windows platforms. |
|
Spotlight on Oracle:
Key Findings in 2005 WinterCorp TopTen Program PDF |
Oracle OpenWorld Presentations
|
|
|
Next Generation Performance and Scalability
in Oracle Database 11g (2007) PDF |
|
|
|
Advanced Compression in Oracle Database 11g
(2007) PDF |
|
|
|
Secure Files - Next Generation Data
Management (2007) PDF |
|
|
|
Oracle Database 11g
Direct NFS Client (2007) PDF |
|
|
|
Real World Performance: Current Trends in
Database Performance (2007) PDF |
|
|
|
Real World Performance: When to Use
Appropriate Technology (2007) PDF |
|
|
|
Detecting Performance Problems Accurately
and Quickly: Essential Diagnostics Techniques for Oracle Database 11g
(2007) PDF |
|
|
|
SQL Plan Management: New Approach for
Providing SQL Performance Stability in Oracle Database 11g
(2007) PDF |
|
|
|
DBAs' New Best Friend: Advanced SQL Tuning
Features of Oracle Database 11g (2007) PDF |
|
|
|
Using Active Session History for
Performance Tuning: Advanced Topics in Performance Diagnostics (2007) PDF |
|
|
|
Best Practices for Performance of Oracle
Database on Windows(2007) PDF |
|
|
|
In-Memory Database Caching Technology and
Customer Deployment Use Cases (2007) PDF |
|
|
|
Oracle Active Data Guard: What They Didn't
Print in the Manuals (2007) PDF |
|
|
|
|
|
|
|
Bookmark
