
Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Cours
Overview
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database 11g Release 1 and Release 2. The Oracle Database 11g Release 2 for Experienced 10g Database Administrators course will give experienced Oracle database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g Release 2. Database administrators will gain a practical understanding of the new features of Oracle Database 11g Release 2 and how these can be implemented in their current Oracle installations.
Prerequisites
Delegates who wish to attend this Oracle Database 11g Release 2 for Experienced 10g Database Administrators course should have good understanding of Oracle Database 10g administration.
Objectives
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the skills needed install, upgrade, implement and support Oracle Database 11g Release 1 and Release 2.
Database administrators will gain a practical understanding of the new features of Oracle Database 11g Release 1 and Release 2 and how these can be implemented in their current Oracle installations.
Outline
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: NEW MANAGEMENT FEATURES
- Log File Changes
- Parameter File Management Changes
- Automatic Diagnostic Repository
- ADRCI Command Line Tool
- Automatic Memory Management
- Memory Advisor Views
- New Management Parameters
Session 2: INSTALLING AND CONFIGURING ORACLE DATABASE 11g
- Install Oracle Database 11g
- Deinstall Oracle Database 11g
- The Database Configuration Assistant
- Online Patching
Session 3: UPGRADING TO ORACLE DATABASE 11g
- Upgrading to Oracle Database 11g Release 1 and 2
- Upgrade the Time Zone File and Timestamp with Timezone Date
- Oracle Parameter Changes
- Online Dictionary View Changes
Session 4: OVERVIEW OF ORACLE RESTART
- Control Oracle Restart
- Use the srvctl Utility
- Manually Add Components to the Oracle Restart Configuration
Session 5: NEW SECURITY FEATURES
- Automatic Secure Configurations
- Default Passwords
- Case Sensitive Passwords
- Profiles and the Password Verify Function
- Default Auditing
- Tablespace Master Key Re-key
- Transparent Tablespace Encryption
- Data Masking
- Oracle SecureFile LOBs
- Access Control Lists on Network Services
- Oracle Secure File Masking
- Security and OEM
Course Contents - DAY 2
Session 6: STORAGE ENHANCEMENTS
- Use 4KB Sector Disks
- Table Compression
- Hybrid Columnar Compression
- Segment Creation on Demand
Session 7: ADDM AND AWR NEW FEATURES
- ADDM New Features
- ADDM New Views
- ADDM for RAC
- Manage ADDM through DBMS_ADDM
- Find Classifications
- Directives
- AWR New Features
- Altered Retention of AWR Snapshots
- AWR Baseline New Features
- Adaptive Metric Thresholds
Session 8: NEW SCHEDULER FEATURES
- Scheduler Automated Maintenance Tasks
- Auto Task Architecture
- Auto Task Dictionary Views
- Use OEM to Manage Auto Task
- Manage Auto Task Manually
- The Auto Task Maintenance Windows
Session 9: SCHEMA MANAGEMENT NEW FEATURES
- DDL Wait Option
- Add Columns with a Default Value
- Virtual Columns
- Improved Online Index Creation and rebuild
- Invisible Indexes
- Read Only Tables
Session 10: APPLICATION DEVELOPMENT NEW FEATURES
- SQL
- New SQL*Plus Commands
- Lock Table Parameter
- Client Side Result Cache
- Server Result Cache
- Use Table Automation to Control Result Caching
- Regular Expression Enhancements
- Named Notation
- PL/SQL
- PL/SQL Function Cache
- Automatic Subprogram Inlining
- PL/SQL Scope
- PL/SQL Native Compilation
- Dynamic SQL in PL/SQL
- Dynamic SQL and REF Cursors
- Trigger Enhancements
- Simple Integer Datatype
- PL/SQL CONTINUE Statement
- Natural Sequences
Course Contents - DAY 3
Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION
- Automatic Block Corruption Reporting
- Automatic Quarantine of Corrupt Redo Segments
- Protection from Data Corruption
- Improvements to Analyze Validate Structure
- Proactive Monitoring with the Health Monitor
Session 12: RECOVERY MANAGER NEW FEATURES
- Automatic Channel Failover
- Parallel Backups
- Compressed Backups
- Improved Handling of Long Term Backups
- Backup Failover of Archived Redo Logs
- Archived Redo Log Deletion Policy
- Undo Backup Optimization
- Improved Block Media Recovery
- Stored Scripts with Substitution Values
- Virtual Private Catalogs
- Merge Catalogs
- Backup up Catalogs
- Active Database Duplication
- TSPITR Enhancements and Modifications
Session 13: DATA RECOVERY ADVISOR
- Overview of the Data Recovery Advisor
- Use the Data Recovery Advisor through OEM
- Use the Data Recovery Advisor through the RMAN Command Line
- Proactive Health Checks with the Validate Command
- Data Recovery Advisor Dictionary Views
Session 14: FLASHBACK TECHNOLOGY
- Flashback Transaction Backout
- Flashback Transaction Wizard
- Enterprise Manager Log Miner Interface
- Oracle Total Recall
- Flashback Data Archive Overview
- Flashback Data Archive Architecture
- Flashback Data Archive Workflow
Session 15: DATABASE REPLAY
- Overview of Database Replay
- The Database Replay Process
- Capture Workload
- PreProcess the Captured Workload
- Replay Workload
- Database Replay Usage
- The DBMS_Workload Package
Course Contents - DAY 4
Session 16: DATA PUMP NEW FEATURES
- Dump File Set Compression
- Encryption Enhancements
- Data Remapping
- Rename Table
- Dump File Overwrite
- Partitioned Tables
- The Transportable Parameter
- The Data_Options Parameter
- The exp Utility Deprecated
- Data Pump Legacy Mode
Session 17: OVERVIEW OF DATA GUARD NEW FEATURES
- Compression of Archived Redo Logs
- Lost Write Detection
- Higher Availability with Fast Start Failover Enhancements
- Real Time Query Capable Physical Standby Database
- Rolling Upgrades to Physical Standby
- Block Change Tracking on a Physical Standby Database
- SQL Apply Logical Standby
- RMAN and Data Guard
- Snapshot Standby Database
- Clone a Running Database
- Oracle Active Data Guard
- Real Time Query Apply Lag Time
Session 18: ORACLE DATABASE ADVISORS
- Repair Advisors and Fault Diagnostics
- The SQL Repair Advisor
- The SQL Access Advisor
- The Streams Performance Advisor
- The Advisor Views
Session 19: OVERVIEW OF ASM CHANGES AND NEW FEATURES
- SYSASM Role
- Disk Group Attributes
- Fast Disk Resync
- Preferred Mirror Read
- Compatibility Settings
- ASM Support for Variable Allocation Unit Sizes
- Drop Diskgroup Force
- The asmcmd Command Line Interface
- New ASM Documentation
- Oracle Database 11g Release 2 New Features
Course Contents - DAY 5
Session 20: NEW DIAGNOSTIC FEATURES
- Oracle Database 11g Fault Diagnostic Automation
- Automatic Diagnostic Workflow
- Problems and Incidents
- Incident Packaging Service
- Temporary Tablespace Shrink
- EM Support Workbench Overview
Session 21: PERFORMANCE TUNING NEW FEATURES
- Improved Statistics Gathering
- Real-Time SQL Monitoring
- Monitoring and Tuning usage model
- Setting up Notification rules
- Using the Advisors
- The SQL Performance Analyzer
- Automatic SQL Tuning
- Manual Creating and Use of SQL Tuning Sets
- Intelligent Cursor Sharing
- SQL Plan Management
- Temporary Tablespace Shrink
- Test Case Builder
- SQL Monitoring in Oracle Database 11g R2
- View Session Details
- View the SQL Monitoring Report
Session 22: DATA WAREHOUSE AND BI NEW FEATURES
- Partitioning Enhancements
- Data Pump Single-Partition Imports
- Materialized Views and Query Rewrite Enhancements
- The PIVOT and UNPIVOT Clauses
- Data Compression
- Enhancements to the Degree of Parallelism
- In Memory Parallel Query
- System Managed Indexes for List Partitioning
Session 23: RESOURCE MANAGER CHANGES AND NEW FEATURES
- I/O Calibration
- Default Maintenance Plan
- Built-In Resource Plans
- Resource Manager Statistics in AWR
- Resource Manager Plan Directive New Features
- Instance Caging