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

oracle 11g 的新特性

相關文章