|
Installation and Upgrade Enhancements
- Install Oracle Database 11g
- Upgrade your database to Oracle Database 11g
- Use online patching
Storage Enhancements
- Create and maintain bigfile tablespaces
- Rename tablespaces
- Create a default permanent tablespace
- Describe Automatic Storage Management (ASM)
- Set up initialization parameter files for ASM and database instances
- Execute SQL commands with ASM file names
- Use ASMCMD Command-Line Interface
- Start up and shut down ASM instances
- Administer ASM disk groups
- Setup ASM fast mirror resynch
- Understand scalability and performance enhancements
SQL Performance Analyzer
- Using SQL Performance Analyzer
SQL Plan Management
- SQL Plan Baseline Architecture
- Set up SQL Plan Baseline
- Using SQL Plan Baseline
Database Replay
- Overview of Workload Capture and Replay
- Using Workload capture and replay
Miscellaneous New Features
- Describe and use the enhanced online table redefinition
- Use fine-grained auditing for DML statements
- Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
- Use Query Result Cache and PL/SQL Result Cache
- Create temporary tablespace groups
- Assign temporary tablespace groups to users
- Temporary Tablespace Enhancements
Oracle SecureFiles
- Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
- Use SQL and PL/SQL APIs to access Secure File LOBS
|
SQL Tuning
- Use the SQL Tuning Advisor
- SQL Access Advisor Overview
- Create SQL Access Advisor analysis session using PL/SQL
- Setup and modify Automatic SQL Tuning
- Interpret reports generated by Automatic SQL Tuning
- Use SQL Repair Advisor
Intelligent Infrastructure Enhancements
- Monitor and maintain the AWR
- Creating and using AWR baselines
- Control Automated Maintenance Tasks
- Using Database Resource Manager New Features
- Simplify management tasks by using the Scheduler
- Create a job, program, schedule and window
- View information about job executions and job instances
- Monitor and manage server-generated alerts
Performance Enhancements
- Use Automatic Database Diagnostic Monitor (ADDM)
- ADDM Enhancements in 11g
- Use Automatic Shared Memory Management
- Setup Automatic Memory Management
- Enhancements in statistics collection
Space Management and Partitioning
- Reduce space related error conditions through proactively managing tablespace usage
- Reclaim wasted space from tables and indexes using the segment shrink functionality
- Use the Segment Advisor
- Use the Undo Advisor
- Use Automatic Undo Retention Tuning
- Implement the new partitioning methods
- Employ Data Compression
Load and Unload Data
- Transport tablespaces across different platforms
- Explain Data Pump architecture
- Monitor a Data Pump job
- Use Data Pump export and import
- Create external tables for data population
|
Backup and Recovery Enhancements
- Simplify file management for all recovery-related file
- Reduce restore time by applying incremental backups to data file image copies
- Simplify recovery after opening the database with the RESETLOGS option
- Speed backup times by creating faster incremental backups
- Minimize load requirements by specifying limits in backup time windows
- Save storage space through writing compressed backup sets
- Managing Archive logs
Using Flashback and Logminer
- Configure and use Flashback Database
- Recover dropped tables with the Flashback Drop feature
- Retrieve row history information with the Flashback Versions Query feature
- Audit or recover FROM transactions with the Flashback Transaction Query feature
- Recover tables to a point in time with the Flashback Table feature
- Back-out transactions using Flashback Transaction
Diagnosability Enhancements
- Setup Automatic Diagnostic Repository
- Use Support Workbench
- Run health checks
Using the Data Recovery Advisor
- Overview of Data Recovery Advisor
- Repairing data failures using Data Recovery Advisor
- Perform proactive health check of the database
Security: New Features
- Configure the password file to use case sensitive passwords
- Encrypt a tablespace
- Configure fined grained access to network services
|
