Oracle Database 11g : New Features for Administrators DBA


This Oracle Database 11g: New Features for Administrators DBA Release 2 training explores new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Participating in hands-on practice sessions help reinforce your understanding of the new capabilities.


Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.


Oracle Database 11g Release 2 (


• 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

• Installing Oracle Database 11g Release 2 • Oracle Database Upgrade Enhancements • Online Patching • Upgrading Your Time Zone File and Timestamp with Time Zone Data

• Controlling Oracle Restart • Using the srvctl Utility • Manually Adding Components to the Oracle Restart Configuration

• 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

• Using 4 KB-Sector Disks • Using Table Compression • Hybrid Columnar Compression • SQL Access Advisor • Segment Creation on Demand

• 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

• Enabling SecureFiles Storage • Creating SecureFiles • Using SecureFile Compression • Accessing SecureFiles Metadata • Migrating to SecureFiles

• 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: 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: 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

• 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 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

• 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

• 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 in Oracle Database 11g Release 2 • Viewing Session Details • Viewing the SQL Monitoring Report

• 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

• Online Redefinition Enhancements • Creating and Using Invisible Indexes

• 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

• Oracle Total Recall • Flashback Transaction Backout • Enterprise Manager LogMiner Interface • Data Pump Legacy Mode

• Assessing Data Failures • Data Recovery Advisor RMAN Command-Line Interface • Data Recovery Advisor Views • Setting Parameters to Detect Corruption


Practice Activities
Case Studies


Pre Test
Post Test
Certification Exam


5 Days

Target Audience

Database Administrators , Sales Consultants , Support Engineer , Technical Consultant , Data Warehouse Administrator


No Schedule