Oracle Grid Infrastructure
- Installing Oracle Grid Infrastructure for a Standalone Server
- Creating an ASM Disk Group
- ASM Cluster File System
- ASM Dynamic Volume Manager
- ASM File System Snapshot
Installation and Upgrade Enhancements
- Installing Oracle Database 11g Release 2
- Oracle Database Upgrade Enhancements
- Online Patching
- Upgrading Your Time Zone File and Timestamp with Time Zone Data
Oracle Restart
- Controlling Oracle Restart
- Using the srvctl Utility
- Manually Adding Components to the Oracle Restart Configuration
ASM Enhancements
- Seting up ASM fast mirror resync
- Using ASM Scalability and Performance Enhancements
- ASM Disk Group Compatibility
- Using ASMCMD Extensions
- ASM File Access Control
- ASM Optimal Disk Placement
Storage Enhancements
- Using 4 KB-Sector Disks
- Using Table Compression
- Hybrid Columnar Compression
- SQL Access Advisor
- Segment Creation on Demand
Data Warehouse and Partitioning Enhancements
- Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
- Degree of Parallelism Enhancements
- In-Memory Parallel Query
- Partitioning Enhancements
- System-Managed Indexes for List Partitioning
Oracle SecureFiles
- Enabling SecureFiles Storage
- Creating SecureFiles
- Using SecureFile Compression
- Accessing SecureFiles Metadata
- Migrating to SecureFiles
Security and Networking Enhancements
- Secure Password Support
- Automatic Secure Configuration
- Managing Default Audits
- Setting Database Administrator Authentication
- Transparent Data Encryption
- Hardware Security Module
- Tablespace Master Key Re-Key
- Supporting IPv6 Address Notification
SQL Performance Analyzer
- SQL Performance Analyzer: Overview
- Using SQL Performance Analyzer
- Using Enterprise Manager to Access SQL Performance Analyzer
- SQL Performance Analyzer: PL/SQL Example
- SQL Performance Analyzer: Data Dictionary Views
SQL Plan Management
- SQL Plan Management: Overview
- Loading SQL Plan Baselines
- Using the MIGRATE_STORED_OUTLINE Functions
- Viewing Important Baseline SQL Plan Attributes
- Loading a SQL Plan Baseline Automatically
- Purging SQL Management Base Policy
Database Replay
- Using Database Replay
- Database Replay System Architecture
- Supported Workloads
- Database Replay Workflow in Enterprise Manager
- Database Replay PL/SQL Procedures
- Database Replay Data Dictionary Views
Automatic SQL Tuning
- Automatic SQL Tuning in Oracle Database 11g
- Selecting Potential SQL Statements for Tuning
- Controlling the Automatic SQL Tuning Task
- Configuring Automatic SQL Tuning
- Using the PL/SQL Interface to Generate Reports
Intelligent Infrastructure Enhancements
- Using New Automatic Workload Repository Views
- Creating AWR Baselines
- Defining Alert Thresholds Using Static Baseline
- Controlling Automatic Maintenance Tasks
- Fixed Policy CPU Resource Management
- Instance Caging
- Scheduler Enhancements
Diagnosability Enhancements
- Seting Up Automatic Diagnostic Repository
- ADRCI: The ADR Command-Line Tool
- Incident Packaging Service (IPS)
- Using the Enterprise Manager Support Workbench
- Invoking IPS Using ADRCI
- Running Health Checks Manually
- Using the SQL Repair Advisor
SQL Monitoring
- SQL Monitoring in Oracle Database 11g Release 2
- Viewing Session Details
- Viewing the SQL Monitoring Report
Performance Enhancements
- Using the DBMS_ADDM Package
- New and Modified Views
- Enabling Automatic Memory Management
- Using New Statistic Preferences Features
- Locking Enhancements
- Adaptive Cursor Sharing
- Using Table Annotation to Control Result Caching
Application Maintenance and Upgrade Enhancements
- Online Redefinition Enhancements
- Creating and Using Invisible Indexes
Backup and Recovery Enhancements
- Using New SET NEWNAME Clauses
- Optimized Backups
- Using New Settings for Binary Compression
- Enhancements to Database Duplication
- Creating Archival Backups
- TSPITR Enhancements and Modifications
- Creating and Using Virtual Private Catalogs
- Introduction to Oracle Secure Backup Cloud Module
Flashback Technology, LogMiner, and Data Pump
- Oracle Total Recall
- Flashback Transaction Backout
- Enterprise Manager LogMiner Interface
- Data Pump Legacy Mode
Data Recovery Advisor
- Assessing Data Failures
- Data Recovery Advisor RMAN Command-Line Interface
- Data Recovery Advisor Views
- Setting Parameters to Detect Corruption