Oracle Database 11g: New Features for Administrators

Содержание

Exam Topics:

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