Oracle Partitioning in Oracle Database 11g

Maclean Liu(刘相兵

Oracle Partitioning Fundamental Concepts for Success


Oracle Partitioning in Oracle Database 11g
Oracle Partitioning Fundamental Concepts for Success

While performance seems to be the most visible one, don't forget about the rest
partitioning must address all business-relevant areas of Performance, Manageability, and Availability  
Partition autonomy is crucial
fundamental requirement for any partition maintenance operations
acknowledge partitions as metadata in the data dictionary

Cf. microsoft where you can not even name a partition, let alone manage it autonomously.

Provide full partition autonomy
Use local indexes whenever possible
Enable partition all table-level operations for partitions, e.g. TRUNCATE, MOVE, COMPRESS
Make partitions visible and usable for database administration
Partition naming for ease of use
Maintenance operations must be partition-aware
Also true for indexes
Maintenance operations must not interfere with online usage of a partitioned table

Oracle Partitioning Enhancements

Complete the basic partitioning strategies
    defines HOW data is going to be partitioned
new composite partitioning methods

Introduce partitioning extensions
    defines WHAT controls the data placement
enhance the manageability and automation
virtual column based partitioning
REF partitioning
interval partitioning
partition advisor

11g_vldb.ppt (2.58 MB, 下载次数: 5, 售价: 10 金钱)

2012-2-29 00:02 上传

点击文件名下载附件
售价: 10 金钱  [记录]

aiirii

下载，学学１１g分区新特性

hello_jacky

好好学习一下

laughing

钱不够，先mark一下。

bjchangxiao

学习一下