O1109 - Oracle 11g New Features 9i DBAs
Availability
| Date | Duration | Price | Location | Enrolment |
|---|
| 10/21/12 | 3 | 1380 | Reading | Please phone 01275 859666 |
| 09/30/12 | 3 | 1380 | London | Please phone 01275 859666 |
| 08/27/12 | 3 | 1380 | Reading | Please phone 01275 859666 |
| 09/11/12 | 3 | 1380 | London | Please phone 01275 859666 |
| 09/23/12 | 3 | 1380 | Reading | Please phone 01275 859666 |
| 10/28/12 | 3 | 1380 | Edinburgh | Please phone 01275 859666 |
Training Course ObjectivesThe course provides a hands environment to practice both the new features and key enhancements in 11g and learn best practise in an upgrade path. For those coming from versions of the database prior to 10g the enhancements are numerous and far reaching.
This unique course objectively assesses this new functionality providing attendees not only with hands on experience to undertake the migration themselves, but also an opportunity to discuss the issues with our experienced team who will provide crucial tips and techniques to ensure the full benefits of 11g are harnessed and the migration route, tested and robust.
Training Course Contents
Training Course Contents
Diagnostic Enhancements
- Fault Management
- Feature Based Patching
- The Alert Log
- Dump Files
- Support Workbench
- Health Checks
Shared Memory Management
- Manual Memory Allocation
- Setting up Automatic Shared Memory Management
- Non-dynamic SGA Buffers
- Tablespace Management
- Default Permanent Tablespace
- Rename Tablespace
- SYSAUX Tablespace
Space Management
- Segment Advisor
- Improved Segment Size Estimation.
- Shrinking Segments
- Undo Advisor
- Automatic Undo Retention Tuning.
Export & Import
- Export, Import and Data Pump
- Directories and Files
- Example of a Data Pump Job
- Data Pump Features
- Data Pump API
- External Tables
- Cross-Platform Transportable Tablespaces.
Automated Storage Management
- ASM Instances and Database Instances.
- ASM Disk Groups
- ASM Files
- Data dictionary Views
Automatic Workload Repository
- Automatic Statistics Collection
- Baselines.
- Workload Repository Views
- AWR Reporting.
- Feature Usage Metrics
- Active Session History (ASH).
ADDM
- ADDM Reporting
- Server Alerts
- Related Views
- Automatic SQL Tuning in Oracle Database 11g.
- SQL Tuning Advisor
- SQL Tuning Advisor Features
Miscellaneous Tuning Features
- Buffer cache flushing
- Optimizer Changes
- Gathering Data Dictionary Statistics.
RMAN Enhancements
- Flash Recovery Area
- Fast Incremental Backups
- Using Image Copies with Incremental Backups.
- Image Copies and the BACKUP Command.
- Catalog Maintenance
- Automatic Instance Creation for RMAN TSPITR.
- Global Stored Scripts
- Backupset Compression
- Restore Preview
- Limiting Backup Duration
- More Robust Backup and Restore.
Security: New Features
- Security Enhancements
- Secure Default Configuration
- Enabling the Built-in Password Complexity Checker.
- Managing Default Audits
- Privileges Audited By Default
- Adjusting Security Settings
- Setting Security Parameters
- Setting Database Administrator Authentication.
Intelligent Infrastructure
- Moving Window Baseline
- Baseline Templates
- Generating Baseline for a Single Time Period.
- Automatic Workload Repository Baselines.
- Performance Monitoring and Baselines.
- Automated Maintenance Tasks
- Resource Manager: New EM Interface.
Who Should Attend
Pre Requisites
-
Working experience of Oracle 8i or 9i databases
-
Oracle DBA Experience
| 