Maclean Liu(刘相兵 发表于 2012-2-29 00:02:51

Oracle Partitioning in Oracle Database 11g

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

aiirii 发表于 2012-7-18 10:15:01

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

hello_jacky 发表于 2013-6-27 14:19:03

好好学习一下

laughing 发表于 2013-10-11 22:59:36

钱不够，先mark一下。

bjchangxiao 发表于 2017-6-12 09:09:30

学习一下
页: [1]
查看完整版本: Oracle Partitioning in Oracle Database 11g