| Technical
Information |
| |
 |
SQL Plan Management in Oracle Database 11g (PDF)
Describes the SQL Plan Management feature introduced in
Oracle Database 11g Release 1.
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. |
|
Oracle9i
for E-Business: Business Intelligence (PDF)
Describes key enhancements in Oracle9i to support
business intelligence and data warehousing. Covers enhancements
to SQL engine, as well as new additions in data mining
and OLAP. |
|
Migrating to the Cost-BasedOptimizer (PDF)
Oracle Database 10g supports the Cost-Based Optimizer
(CBO). Oracle's legacy optimizer, the Rule-Based Optimizer
(RBO), is no longer supported. While most applications
running on Oracle today use the CBO, some applications
continue to use the RBO. This paper describes the steps
in migrating an application from the RBO to the CBO. |
|
Data
Warehouse Performance Enhancements with Oracle9i
(PDF)
Measures performance improvements of Oracle9i
versus Oracle8i for real-world DW tasks. Shows
timings for loading, querying and maintenance for a 12-processor
system. |
|
Oracle9i
Performance and Scalability in DSS Environments (PDF)
Measures performance improvements of Oracle9i
versus Oracle8i using several different size
data sets. Timings were performed on a 10-processor system.
|
| |
Improving Performance using Query Rewrite in Oracle Database
10g (PDF)
Significant performance gains can often be achieved using
query rewrite and materialized views, and this white paper
shows how these performance gains can be achieved without
changing applications. |
| |
Performance Tuning Using the SQLAccess Advisor (PDF)
SQLAccess Advisor, a tool run from Advisor Central in
Oracle Enterprise Manager, recommends indexes and materialized
views. It provides convenient and efficient tuning guidance.
|
| |
Improve Results with Query Rewrite (HTML - Oracle
Mag.)
Describes the types of query rewrites Oracle's query optimizer
can perform and then discusses tools to help determine
the best set of materialized views to create for enabling
the optimizer to rewrite many queries. |
|
It's
The Little Things That Count: Index Skip Scan (HTML -
Oracle Mag.)
Index skip scan, introduced in Oracle9i, enables
a composite index to be used in a query even if the query
constraints do not refer to its lead column. This eliminates
the choice between performing full table scans or creating
multiple indexes. |
Bookmark
