 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Which Partitioning Technique Do I Choose?
Range/hash composite partitioning provides the manageability and
availability benefits of range partitioning with the data
distribution advantages of hash partitioning. Data skew is unlikely,
because the user can always add or drop subpartitions within a
partition to maintain even distribution of each container. Rolling
windows of historical data are easily maintained by adding or
dropping primary partitions with no effect on subpartitions in other
primary partitions.
The range-list composite partitioning method
provides for partitioning based on a two-level hierarchy. For
example, the primary partition could be based on a date range to
allow rolling window operation to occur and the second level could
be based on a logical grouping (a list of state codes (i.e. PA, NY,
OH, etc.) is an good example of a logical grouping). The data would
be divided according to the date range and divided again according
to the state’s abbreviation.
The Oracle Database Performance Tuning
(1Z0-033) certification test will contain a few questions on
tablespace partitioning. Test candidates should understand:
-
The basic partitioning algorithms (range, list,
hash, composite)
-
How to specify partitioning during table
creation
-
When to use a specific partitioning algorithm
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
