product logo 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.

Highlighted Tip/Article Technical Information Benchmarks and News
Real-World Scalability Oracle OpenWorld Presentations  

Highlighted Tip/Article
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.


Technical Information
Oracle Advanced Compression with Oracle Database 11g Release 2 PDF
Database Performance and Scalability with Oracle Database 11g Release 1 PDF
SecureFiles Performance with Oracle Database 11g Release 1 PDF
Ingest, Scale and Manage Data Explosion using Oracle SecureFiles on a LSI 7900 Storage Array PDF
SQL Plan Management in Oracle Database 11g Release 1 PDF
SQL Performance Analyzer in Oracle Database 11g Release 1 PDF
Oracle Direct NFS Client with Oracle Database 11g Release 1 PDF
In-Memory Database Cache Data Sheet PDF
Using Oracle In-Memory Database Cache to Accelerate the Oracle Database (Technical Whitepaper) PDF

more

Benchmarks and News
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 Performance Oracle
TPC-C Price/Performance Oracle
TPC-H @ 1,000 GB Oracle
TPC-H @ 3,000 GB Non-Clustered Oracle
TPC-H @ 10,000 GB Non-Clustered Oracle
TPC-H @ 30,000 GB Oracle
SAP Sales and Distribution 2-tier Oracle
SAP Sales and Distribution Parallel Oracle
SAP Business Intelligence-Data Mart (BI-D) Oracle
As of November 18, 2009:
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. The SAP BI-D Standard Application Benchmark performed on October 13,2009 by Fujitsu in Walldorf, Germany has been certified with the following data: Throughput/hour (query navigation steps): 1,165,742. CPU utilization of servers: 88% (Node 1 active: 89%. Node 2 active: 88%. Node 3 active: 88%. Node 4 active: 88%). Operating system all servers: SuSE Linux Enterprise Server 10. RDBMS: Oracle 10g Real Application Clusters (RAC). Technology platform release: SAP NetWeaver 7.0 (Non-Unicode). Configuration: 4 servers (4 active nodes): Fujitsu Primergy RX300-S5, 2 processors / 8 cores / 16 threads, Intel Xeon Processor X5570, 2.93 GHz, 64 KB L1 cache and 256 KB L2 cache per core, 8 MB L3 cache per processor, 96 GB main memory. Certification Number 2009045.
more

Oracle Performance in the News
Oracle® Database 11g on Windows-based Dell PowerEdge Server Achieves World Record for Price/Performance with TPC-C Benchmark
Oracle and Sun Are Faster than IBM: Proof Now Available: Oracle and Sun SPARC SOLARIS World Record TPC-C Performance Beats IBM's Best Results on DB2 with Power 595 Server
Oracle® Database on Sun’s Intel®-based Blade Module Sets World Record Result on SAP® Sales and Distribution-Parallel Standard Application Benchmark with the SAP Enhancement Package 4 for SAP ERP 6.0 (Unicode).
Oracle® Database on Fujitsu Server Cluster Delivers World Record Result with SAP® Business Intelligence Data Mart Standard Application Benchmark – Outperforms Best IBM DB2 Result by More than Three Times
Oracle Delivers World Record Result for a Two-Processor System Running SAP® Enhancement Package 4 for SAP ERP 6.0 on the Two-tier SAP Sales and Distribution Standard Application Benchmark
Oracle® Database 11g Sets New World Record For Price/Performance with TPC-C Benchmark
Oracle Sets New World Record Four-Processor Server Result on the SAP® Two-Tier Sales and Distribution Standard Application Benchmark Running SAP Enhancement Pack 4 for SAP ERP 6.0
Oracle® Database 11g Continues to Deliver Record Results with TPC-C Benchmark
Oracle Sets New World Record Result for a Two-Processor Server running SAP ERP 6.0, Enhancement Pack 4 with the Two-Tier SAP Sales and Distribution Standard Application Benchmark
Oracle® Database 11g Sets Another TPC-C Price/Performance World Record
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 Advanced Compression: Reduce Storage, Reduce Costs, Increase Performance (2009) PDF
Database File System (DBFS) and SecureFiles (2009) PDF
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

 
Left Curve
Learn More
Right Curve
 · Partitioning
 · Advanced Compression
 · SecureFiles
 · Results Cache
 · DB Resident Connection Pools
 · Real Application Testing
 · Real Application Clusters
 · Active Data Guard
 · In-Memory Database Cache
 · Net Services
 · Data Warehouse Performance
 · Data Warehouse Scalability

Left Curve
Performance Documentation
Right Curve
 · 2 Day + Performance Tuning Guide
 · Performance Tuning Guide

Left Curve
Training and Tutorials
Right Curve
 · Advanced Compression (OBE)
 · SecureFiles (OBE)
 · Results Cache (OBE)
 · Active Data Guard (OBE)
 · Multi-Column Stats (OBE)
 · Gathering and Publishing Optimizer Stats (OBE)
 · Updatable In-Memory Database Cache(OBE)
 · Read only In-Memory Database Cache (OBE)
 · SQL Plan Management (OBE)
 · SQL Performance Analyzer (OBE)

Left Curve
Demos
Right Curve
 · Automatic SQL Tuning
 · Advanced Compression
 · SQL Access Advisor and SQL Performance Analyzer
 · SQL Monitoring
more

Left Curve
Articles
Right Curve
 · SecureFiles (Oracle Magazine)
 · Direct NFS Client (ComputerWeekly.com)
 · 11g Top Features: Adaptive Cursor & SQL Plan Management
 · 11g Top Features: SQL Access Advisor
 · 11g Top Features: SQL Performance Analyzer
 · 11g Top Features: Caching & Pooling
 · 11g Top Features: Partitioning
 · Results Cache (Tom Kyte)

Left Curve
Competitive Comparisons
Right Curve
 · IBM DB2
 · Microsoft SQL Server 2005

Left Curve
Related Technologies
Right Curve
 · Grid
 · Manageability
 · Real Application Clusters
 · Business Intelligence and Data Warehousing
 · High Availability

Left Curve
Discussion Forums
Right Curve
 · Oracle Database
 · SQL & PL/SQL
 · Grid

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy