Oracle Data Warehouse Tuning for 10g
Taking users beyond the basics to critical issues in running the most efficient data warehouse applications, this book illustrates how to keep data going in and out in the most productive way possible.
TABLE OF CONTENTS Oracle Data Warehouse Tuning for 10g
Appendix A: New Data Warehouse Features in Oracle Database 10g
Overview
-
The MODEL clause is new allowing for a complex spreadsheet, like multiple dimensional calculations. See Chapter 10.
-
SQLAccess Advisor offers improved access to advisory information previously catered for by the DBMS_ADVISOR package. This tool is not covered in this book and is delayed until the release of Oracle Database 10.2, in a future edition of this book, or another Oracle Database tuning title. [1]
-
DBMS_ADVISOR.TUNE_MVIEW provides advice for materialized views in terms of fast refresh and query rewrite.
-
Materialized view refresh capabilities are improved for refresh, including nested refresh capability.
-
Query rewrite is improved.
-
Index organized tables can now be partitioned.
-
The Oracle SQL DML MERGE statement is enhanced. [2]
-
Oracle Managed Files (OMF) provides automation of underlying datafiles, redo log files, archive redo log files, and control files. Automatic Storage Management (ASM) manages the disks as well, as an additional extension to OMF. OMF will simplify management, but is reputed to hurt performance.
[1]Chapter15 in Oracle SQL: Jumpstart with Examples (ISBN: 1555583237)
[2] Oracle Performance Tuning for 9i and 10g (ISBN: 1555583059)
A.1 Endnotes
-
Chapter 15 in Oracle SQL: Jumpstart with Examples (ISBN: 1555583237)
-
Oracle Performance Tuning for 9i and 10g (ISBN: 1555583059)
Copyright Elsevier Inc. 2005 under license agreement with Books24x7
