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

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		Slides
	Database File System (DBFS) and SecureFiles (2009) PDF		Slides
	Oracle Database 11g: Next Generation Performance and Scalability (2008) PDF		Slides
	Oracle Advanced Compression: Throw Away Half Your Disks and Run Your Database Faster (2008) PDF		Slides
	Boost Your Database Performance 10x with SecureFiles (2008) PDF		Slides
	Running Oracle Database on Flash: Insights From Oracle Development (2008) PDF		Slides
	Advanced Compression in Oracle Database 11g (2007) PDF		Slides
	Secure Files - Next Generation Data Management (2007) PDF		Slides
	Oracle Database 11g Direct NFS Client (2007) PDF		Slides
	Real World Performance: Current Trends in Database Performance (2007) PDF		Slides
	Real World Performance: When to Use Appropriate Technology (2007) PDF		Slides
	Detecting Performance Problems Accurately and Quickly: Essential Diagnostics Techniques for Oracle Database 11g (2007) PDF		Slides
	SQL Plan Management: New Approach for Providing SQL Performance Stability in Oracle Database 11g (2007) PDF		Slides
	DBAs' New Best Friend: Advanced SQL Tuning Features of Oracle Database 11g (2007) PDF		Slides
	Using Active Session History for Performance Tuning: Advanced Topics in Performance Diagnostics (2007) PDF		Slides
	Best Practices for Performance of Oracle Database on Windows(2007) PDF		Slides
	In-Memory Database Caching Technology and Customer Deployment Use Cases (2007) PDF		Slides
	Oracle Active Data Guard: What They Didn't Print in the Manuals (2007) PDF		Slides