| Installation and Upgrade Enhancements |
| [ ] |
Install Oracle Database 11g |
| [ ] |
Upgrade your database to Oracle Database 11g |
| [ ] |
Oracle Direct NFS |
| [ ] |
Use online patching |
| Storage Enhancements |
| [ ] |
Setup ASM fast mirror resynch |
| [ ] |
Understand scalability and performance enhancements |
| [ ] |
Setup ASM disk group attributes |
| [ ] |
Use various new manageability options |
| [ ] |
Use the md_backup, md_restore, and ASMCMD extensions |
| Intelligent Infrastructure Enhancements |
| [ ] |
Creating and using AWR baselines |
| [ ] |
Setting AWR Baseline Metric Thresholds |
| [ ] |
Control Automated Maintenance Tasks |
| [ ] |
Using Database Resource Manager New Features |
| [ ] |
Using new scheduler features |
| Performance Enhancements |
| [ ] |
ADDM Enhancements |
| [ ] |
Setup Automatic Memory Management |
| [ ] |
Enhancements in statistics collection |
| Partitioning and Storage-Related Enhancements |
| [ ] |
Implement the new partitioning methods |
| [ ] |
Employ Data Compression |
| [ ] |
SQL Access Advisor Overview |
| [ ] |
Create SQL Access Advisor analysis session using PL/SQL |
| Using RMAN Enhancements |
| [ ] |
Managing Archive logs |
| [ ] |
Duplicating a Database |
| [ ] |
Back up large files in multiple sections |
| [ ] |
Perform Archival Backups |
| [ ] |
Manage Recovery Catalogs |
| [ ] |
Create a virtual private catalog for RMAN |
|
| Using Flashback and Logminer |
| [ ] |
Overview of Flashback Data Archive |
| [ ] |
Manage Flashback Data Archive |
| [ ] |
Back-out transactions using Flashback Transaction |
| [ ] |
Working with Logminer |
| Diagnosability Enhancements |
| [ ] |
Setup Automatic Diagnostic Repository |
| [ ] |
Use Support Workbench |
| [ ] |
Run health checks |
| [ ] |
Use SQL Repair Advisor |
| Database Replay |
| [ ] |
Overview of Workload Capture and Replay |
| [ ] |
Using Workload capture and replay |
| 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 |
| 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 |
|
| Miscellaneous New Features |
| [ ] |
Describe and use the enhanced online table redefinition |
| [ ] |
Enhanced finer grained dependency management |
| [ ] |
Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes |
| [ ] |
Use Query Result Cache and PL/SQL Result Cache |
| [ ] |
Adaptive Cursor Sharing |
| [ ] |
Temporary Tablespace Enhancements |
| SQL Performance Analyzer |
| [ ] |
Overview of SQL Performance Analyzer |
| [ ] |
Using SQL Performance Analyzer |
| SQL Plan Management |
| [ ] |
SQL Plan Baseline Architecture |
| [ ] |
Set up SQL Plan Baseline |
| [ ] |
Using SQL Plan Baseline |
| Automatic SQL Tuning |
| [ ] |
Setup and modify Automatic SQL Tuning |
| [ ] |
Interpret reports generated by Automatic SQL Tuning |
|