首页 > Linux操作系统 > Linux操作系统 > 准备上 11g 了,了解下新特性

准备上 11g 了,了解下新特性

原创 Linux操作系统 作者:tolywang 时间:2009-05-21 15:04:03 0 删除 编辑


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

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


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


39.Discuss the increased cursor shareability

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

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。


  • 博文量
  • 访问量