- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
1#
发表于 2012-2-29 00:02:51
|
查看: 6461 |
回复: 4
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 金钱)
|
|