Oracle 11g new feature
EXEM Knowledge Base
Oracle 11g new feature중 Performance에 관련한 부분은 다음과 같다.
- Enhanced Partition Pruning Capabilities
- Intelligent Cursor Sharing
- Binding and Defining Multiple Buffers in OCI
- Bitmap Join Index Support for Index-Organized Tables
- Cost-Based Optimizer Enhancements
- Network/OCI Fusion
- OCI Descriptor Array Allocation
- OCI Implicit ROWID Fetching
- PL/SQL Function Result Cache
- PL/SQL Native Compilation Without Needing a Third-Party C Compiler
- Query Result Cache
- Enhanced I/O Statistics
- Database Replay
- Automatic Memory Management
- Automatic Diagnostic Repository
- Health Monitor