Key features that everyone will be interested in include:
- Awesome change ensurance features with Database Replay and SQL Replay.
- Secure Files (next generation LOBs). Significantly faster than LOBs with more flexbility.
- SQL Plan Management.
- Java, XML DB, PL/SQL, APEX and PHP add a lot of performance and feature enhancements.
- Excellent enhancements in compression and encryption across the board.
- Very nice enhancements to partitioning, including automatic partitioning. New Partition Advisor.
- Read only tables, Virtual columns and invisible indexes
- Upgrade and downgrade enhancements.
- Solid enhancements in RMAN, RAC, Data Guard and Data Pump
- Automatic Diagnostic Repository.
- ASM enhancements include Fast Mirror Resyncs, rolling upgrades, new SYSASM role and migrations to ASM.
- Enhancements to temporary tablespaces.
- Read only tables.
Labels: Oracle Database 11g