back to Course Categories | back | print
Oracle 11gR2: New Features for DBAs          

Duration: 5 days

Description 
This intense five-day course is designed to develop proficiency in features new in Oracle11g. This course covers new features in Oracle11g Release 1 and Release 2. Topics include new features in SQL Plan management, SQL baselines, Automatic SQL Tuning, RMAN features, Data Recovery Advisor, Database Replay, Security, Resource management, Data Guard, RMAN, OEM, SQL Performance Analyzer, data warehousing, Oracle Restart and Automatic Storage Management. Hands-on labs will develop skill with the new features in Oracle11g.

Topics

  • Installing Oracle Database 11gR2
  • Oracle Grid Infrastructure
  • Table Compression
  • Hybrid Columnar Compression
  • New features in Java, XML DB, Pl/SQL and APEX
  • New PHP features
  • Virtual columns
  • Invisible indexes
  • Upgrade and downgrade enhancements
  • Automatic Diagnostic Repository.
  • ASM enhancements
  • Fast Mirror Resyncs
  • New SYSASM role
  • Enhancements to temporary tablespaces
  • Enhancements to read only tables
  • SQL Access Advisor
  • Segment Creation
  • SecureFiles (next generation LOBS)
  • SecureFile Compression
  • SecureFiles Metadata
  • Secure Password Support
  • Managing Default Audits
  • Database Administrator Authentication
  • Transparent Data Encryption
  • Tablespace Master Key
  • ASM Cluster File System
  • ASM Disk Groups
  • ASMCMD enhancements
  • ASM File Access Control
  • ASM Optimal Disk Placement
  • ASM Dynamic Volume Manager
  • ASM File System Snapshot
  • Controlling Oracle Restart
  • srvctl utility
  • Upgrading Time Zone information
  • Parallelism Enhancements
  • In-Memory Parallel Query
  • Partitioning Enhancements
  • Partition: System Managed Indexes
  • SQL Performance Analyzer
  • PL/SQL Features
  • SQL Performance Analyzer Data Dictionary Views
  • SQL Plan Management
  • SQL Plan Baselines
  • MIGRATE_STORED_OUTLINES
  • SQL Plan Baseline
  • SQL Management Base Policy
  • Automatic SQL Tuning
  • Analyzing SQL Statements
  • Configuring Automatic SQL Tuning
  • SQL Tuning Reports
  • Automatic Workload Repository Views
  • AWR Baselines
  • Alter Thresholds
  • Fixed policy CPU Resource
  • Scheduler enhancements
  • SQL monitoring
  • Session details
  • SQL monitoring report
  • DBMS_ADDM enhancements
  • Automatic Memory Management
  • Locking features
  • Adaptive cursor sharing
  • Table annotation and result caching
  • Online redefinition enhancements
  • Invisible indexes
  • Optimized backups
  • Database duplication
  • Archival Backups
  • TSPITR features
  • Virtual private catalogs
  • Oracle Secure Backup Cloud Module
  • Total Recall
  • EM LogMiner Interface
  • Data Pump legacy mode
  • Managing Data Failures
  • Recovery Advisor RMAN interface
  • Recovery Advisor Views
  • Detecting Corruption
  • Prerequisites

  • A solid background in Oracle database administration and knowledge in Oracle 10g features.

  •  
     
     

    Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
    email: info@trubix.com
    ....................................................................................................................................................................

    Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
    Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
    SQL Server / .NET / Tools / DB2 Classes / Public Classes

     

     
    all content property © 2006, 2007Trubix Inc.| site design by Art Z design