New partition pruning features of 10g

As I mentioned earlier I started working with our data warehouse team on their migration project; Planning and Testing the 9iR2 to 10gR2 migration of our XXX Tb DWH

I will be testing Oracle’s 10gR2 features for performance. So before tests in details, I also wanted to mention some important very large Oracle database init.ora 10g parameters additional to ASM and CBO configurations I already mentioned; Listing 177a – Some important very large Oracle database init.ora 10g parameters

During some initial tests I experienced new partition pruning features of 10g; “PARTITION RANGE OR”-“KEY(OR)” and “PARTITION RANGE MULTI-COLUMN”-“KEY(MC)” access paths; Code Listing 177b – New partition pruning features of 10g

These tests will be really cool :)

Testing Information : the scripts mentioned are tested on Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

References Used :
Note:368055.1
Subject: Deployment of very large databases (10TB to PB range) with Automatic Storage Management (ASM)

Oracle Database 10g (10.2 & 10.1) New Features in Data Warehousing

Oracle10g-Features für Warehouses by Sven Vetter

Top Ten New Data Warehousing Features In Oracle Database 10g by Mark Rittman

Oracle Database 10g: Top Features for DBAs Release 2 Features Addendum by Arup Nanda
Part 4: Data Warehousing and Integration Features

Advertisement