10g database logo Business Intelligence Features - Optimization
Oracle Database 11g builds on a powerful array of query optimization features that maximize performance.
Technical Information
 SQL Plan Management in Oracle Database 11g (PDF)
Describes the SQL Plan Management feature introduced in Oracle Database 11g Release 1 and covers functionality added in Oracle Database 11g Release 2. The feature ensures that no new query execution plan is used unless its performance has been verified as better than or comparable to the current plan.
 Comparison of Materialized Views & Analytic Workspaces in Oracle Database 11g (PDF)
Compares the approach of using materialized views and query rewrite and analytic workspaces using Oracle Database 11g.
 Conducting a Data Warehousing Benchmark (PDF)
Highlights key issues in planning and resourcing data warehousing benchmarks to gain maximum decision-making value.
 Upgrading from Oracle 9i to 10g:  What to Expect from the Optimizer (PDF)
This paper describes differences in the Cost Based Optimizer between Oracle 9i and Oracle 10g. The paper's coverage includes new statistics, new default parameter values, a new automatic statistics gathering job and more.
 HP Integrity Superdome Cluster with Oracle Database 10g and Oracle Real Application Clusters (PDF)
A world-record 10-TB TPC-H performance benchmark is described in this joint HP-Oracle paper. Oracle Database 10g and Oracle Real Application Clusters (RAC) ran on a two-node, 64-way, HP Integrity Superdome cluster.
 HP ProLiant Cluster with Oracle Database 10g and Oracle Real Application Clusters (PDF)
Record breaking 1-TB TPC-H performance is presented in this joint HP-Oracle paper. The benchmark used Oracle Database 10g with Oracle Real Application Clusters and a 12-node cluster of HP ProLiant servers running Linux.
 DSS Performance in Oracle Database 10g Release 2 (PDF)
Oracle Database 10g Release 2 enables transparent performance enhancements for vital operations including sort and aggregation. Other enhancements improve performance with partitioned tables and for data mining. The paper benchmarks the new features against Oracle Database 10g Release 1.
 Sort Performance Improvements in Oracle Database 10g Release 2
Sort operations are much faster in Oracle Database 10g Release 2. This paper describes the new sort characteristics and gives benchmark results.
 Security and the Data Warehouse (PDF)
Presents the wide range of security features available in Oracle Database 10g data warehouses.
 Query Optimization in Oracle Database 10g Release 2 (PDF)
Oracle's query optimizer is unmatched in the breadth of techniques it applies to query processing. This paper discusses all major areas of query optimization in detail.
 On-Time Data Warehousing with Oracle Database 10g - Information at the
Speed of your Business (PDF)

Discusses what real-time means for data warehousing and defines the concept of “on-time” information availability.
 Materialized Views in Oracle10g (PDF)
Materialized views are used to implement “summary tables” in a data warehouse and can vastly enhance query performance. This white paper describes materialized view functionality in detail.
 Key Data Warehousing Features in Oracle10g: A Comparative Analysis (PDF)
Range partitioning and bitmap indexes are extremely powerful features for optimizing data warehouse performance. This paper compares performance of a database that uses these features to an identical database that does not.
 DSS Performance in Oracle Database 10g Release 1 (PDF)
Oracle Database 10g Release 1 provides significant performance enhancements automatically, with no extra deployment costs or resource requirements. This paper measures performance gains from the new features used on a test database.
Left Curve
Learn More
Right Curve
  · Training
  · Oracle By Example
  · Oracle Forum - Database
BIWA - the Oracle BI, Data Warehousing and Analytics SIG. Join Today!

Left Curve
Related Technologies
Right Curve
  · Oracle BI Home
Oracle Warehouse Builder
Oracle Database BI
Oracle OLAP
Oracle Data Mining