 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. |
|
|
 |
| Have you ever looked through an AWR report
and needed to see more information about a particular SQL statement? Or
perhaps wanted to get more detail on a SQL statement that may have been
performing well one day, but had regressed the next? This information
is available in AWR and can be viewed using the AWR SQL report that was
introduced in Oracle Database 10gR2. Take a
look at the Tips
on Performance Diagnosis Using AWR SQL Report. This report
provides additional
information for a SQL statement, including execution plans and
corresponding SQL statistics for the different execution plans. |
|
|
|
| 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
@ 1,000 GB Non-Clustered |
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 2-tier |
Oracle |
| SAP
Sales and Distribution Parallel |
Oracle |
|
As
of July 17, 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. The SAP SD 2-tier Standard Application Benchmark
performed on June 28, 2008
by Sun Microsystems and Fujitsu has been certified with the following
data: 39,100 SAP SD Benchmark users, 1.94 seconds average
dialog response time, 3,931,330 fully processed order line items per
hour, 11,794,000 dialog steps per hour, 196,570 SAPS. Server
configuration: SPARC Enterprise Server M9000, 64 processors/256
cores/512 threads, SPARC 64 VII, 2.52 GHZ, 64 KB (D) + 64 KB (1) L1
cache per core, 6 MB L2 cache per processor, 1024 GB main memory,
running Solaris 10, Oracle Database 10g and SAP ERP 6.0.
Certification Number 2008042. |
| more |
Oracle
Performance in the News
|
 |
Oracle®
Database 11g Sets New World Record TPC-H One Terabyte Non-Clustered
Benchmark Result on Sun SPARC Enterprise Server |
|
Oracle Sets New
World Record on the SAP® Two-Tier Sales and Distribution
Standard Application Benchmark |
|
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
|
|
|
Oracle Database 11g: Next Generation Performance and
Scalability (2008) PDF |
|
|
|
Oracle Advanced Compression: Throw Away
Half Your Disks and Run Your Database Faster
(2008) PDF |
|
|
|
Boost Your Database Performance 10x with
SecureFiles
(2008) PDF |
|
|
|
Running Oracle Database on Flash: Insights From Oracle Development
(2008) 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
