Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

2135

积分

502

好友

184

主题
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 金钱)
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569   
2#
发表于 2012-7-18 10:15:01
下载,学学11g分区新特性

回复 只看该作者 道具 举报

3#
发表于 2013-6-27 14:19:03
好好学习一下

回复 只看该作者 道具 举报

4#
发表于 2013-10-11 22:59:36
钱不够,先mark一下。

回复 只看该作者 道具 举报

5#
发表于 2017-6-12 09:09:30
学习一下

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-29 02:25 , Processed in 0.054613 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569