明天，2007年7月11日，Oracle 11g将正式发布，也就是说，从明天起，我们就可以去下载11g，正式一睹11g的芳容了。在11g众多的新特性中，你最喜欢哪一点呢？
先简单列一下这些新特性吧：
- 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
其中，最能吸引我的，莫过于
Query a physical standby database while redo is applied
这个巨大的改进，我相信，如果稳定以后，将把物理standby的稳定性，与实时只读特性完美结合，实现了最为完美的读写分离。
那个时候，加上stream的进一步改进，相信shared plex的麻烦可就来了。
评论 (10)
