For the latest consensus on using multiple blocksizes in Oracle, see
The latest consensus on multiple
The best of
OMBDB: An Innovative Paradigm for Data Warehousing Architectures -
Anthony D. Noriega
In one of the most innovative
presentations at IOUG Live! 2005, Anthony Noriega made a very
insightful presentation about the massive benefits of using the
Oracle9i multiple block size feature to optimize Oracle data
Managing a multi-block data
warehouse database falls in a special category that involves
business intelligence and combines expertise in areas such as
Extract Transform Load (ETL), On-Line-Analytical Process (OLAP),
Data Mining, in conjunction with custom applications, legacy
systems, and related business process applications, such as
Supply Change Management (SCM), Customer Relationship Management
(CRM), and Enterprise Resource Planning (ERP) systems.
This paper intends to
enhance a blueprint for major production applications in VLDB.
The paper and presentation will discuss how to best utilize
multiple block size databases in conjunction with table
partitioning and related techniques, table compression, and best
strategies for extent and segment space management and related
tablespace utilization, including best Index Allocation, Index
Organized Tables benchmarks.
I have long been a proponent of
multiple blocksizes for the Oracle data warehouse, and Mr.
Noriega shared some insights from his personal experience:
Utilizing Oracle multiblock
databases in data warehousing based systems will prove in the
long-term to be a reliable methodology to approach the diversity
of information and related business intelligence applications
processes when integrating existing systems, consolidating older
systems with existing or newly created ones, to avoid redundancy
and lower costs of operations, among other factors.
The input received from
those already using multiblock databases in highly satisfactory
in areas such as marketing, advertisement, finance,
pharmaceutical, document management, manufacturing, inventory
control, and entertainment industry.
Overall, Mr. Noriega get my award
for the most innovative technology at IOUG Live! 2005 with this
excellent leveraging of Oracle technology for data warehouse