准备上 11g 了，了解下新特性-优快云博客

oracle 11g发布在即，简单的看了一下11g new feature的介绍，发现有些功能还是比较不错的，先列一下我目前看到的new feature

Use ASM Fast Mirror Resync to improve disk failure recovery times
Set up ASM Fast Mirror Resync using SQL
Configure preferred mirror groups using the ASM_PREFERRED_READ_FAILURE_GROUPS parameter
Use the SYSASM privilege to manage ASM disks
Use the compatibility modes for disk groups
Use ASMCMD command extensions to back up and restore disk groups
Discuss LOB improvements using SecureFiles
Use temporary tablespace enhancements
Perform. proactive failure checks using the Data Recovery Advisor
Enable tracking of table data using Flashback Data Archive
Back out data changes using flashback transaction
Configure archive log deletion policies
Duplicate active databases using Oracle network (without backups)
Back up large files in multiple sections
Create archival backups for long-term storage
Query a physical standby database while redo is applied
Control the location of SQL Apply event information
Set the retention target for remote archived log files
Use the logical standby database flash recovery area
Create a snapshot standby database
Configure the password file to use case-sensitive passwords
Use TDE support on a logical standby database
Use TDE support for Streams
Create a tablespace with encryption for added security
Store external encrypted data using the Hardware Security Module
Use LOB encryption for SecureFile LOBs on per-column or per-partition basis
Use EM to manage your database security options
Set up and modify Automatic SQL Tuning
Create AWR Baselines for future time periods
Use additional supplied maintenance windows for specific maintenance tasks
Simplify memory configuration by setting MEMORY_TARGET initialization parameters
Improve file accessibility of the SPFILE file
Perform. clusterwide analysis of performance using RAC-aware ADDM
Implement partitioning on tables, indexes, and materialized views from SQL Access Advisor’s recommendations
Use partitioning enhancements to gain significantly faster data access
Gain flexibility in automatic statistic generation at the object level
Use memory efficiently with Query Result Cache support
Gain execution speed by using automatic native PL/SQL and Java compilation
Discuss the increased cursor shareability

这里列了39项，但实际上还没公布的肯定还有很多，从已经公布的功能来看，我看了功能介绍觉得9，13，16，39还是比较实用。

9.Perform. proactive failure checks using the Data Recovery Advisor

Data Recovery Advisor 这个功能我是比较看中的，通过和EM的整合，数据库恢复的效率明显可以提高，从功能介绍的PPT来看，EM不仅能给出错误原因，还能给出RMAN恢复脚本，DBA可以选择由EM来自动做或者自己手工执行脚本，把复杂的事情做的越来越易用，oracle这一点我觉得做的非常好，DBA不需要过多的纠缠于各种各样的命令，当然DBA要知道自己做的操作对数据库将会有什么影响，所以对DBA的要求并没有降低，只是体力劳动减少了。

13.Duplicate active databases using Oracle network (without backups)

这个功能也不错，可以在线Duplicate database，这在创建standby database时非常有用，我们不再需要有一份rman备份来做standby database，直接可以从active database来创建standby database，而且em也提供了图形化的操作，非常简化整个过程。

16.Query a physical standby database while redo is applied

这个功能每个DBA都在期待，毫无疑问我会为它欢呼。我们一下子就有了最稳定的同步方案，要实现多站点读写分开的公司有福了！

39.Discuss the increased cursor shareability

这个功能和上述几个功能比起来不是那么显眼，不过我觉得还是有一定价值的。大家都知道以前oracle的bind peeking有个缺陷就是它只会在第一次解析的时候做一个peeking，后续的bind value他就不管了，11g的这个新功能推出以后就不会有这种事情了，oracle会根据bind value的selectivity来看是share cursor还是reparse。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-600673/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-600673/