Back to Search Results

Training Course Summary:

This course is intended to familiarise the Oracle 9i DBA with new features of both 10g and 11g database, perhaps as part of a planned upgrade from Oracle 9i to Oracle 11g database.

Pre-Requisites:

Programming Experience
Oracle 9i DBA Experience
PC Fundamentals

Who Should Attend:

Oracle 9i DBAs

Training Course Overview/Content:

Introduction
Oracle Database Innovation
Enterprise Grid Computing
back to top
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
back to top
Space Management
Segment Advisor
Improved Segment Size Estimation.
Shrinking Segments
Undo Advisor
Automatic Undo Retention Tuning.
back to top
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.
back to top
Flashback
Enabling Flashback
Flashback Query
Additional Query Functions
Flashback Version Query
Flashback Transaction Query
Flashback Table
Flashback Drop (Recycle Bin)
Flashback Database
back to top
Automated Storage Management
ASM instances and database instances
ASM Disk groups
ASM Files
Data dictionary Views
back to top
Automatic Workload Repository
Automatic Statistics Collection
Baselines
Workload Repository Views
AWR Reporting
Feature Usage Metrics
Active Session History (ASH)
back to top
ADDM
ADDM Reporting
Server Alerts
Related Views
SQL Tuning Advisor
SQL Tuning Advisor Features
back to top
Miscellaneous Tuning Features
Buffer cache flushing
Optimizer Changes
Gathering Data Dictionary Statistics
back to top
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
back to top
Tablespace Management
Default Permanent Tablespace
Rename Tablespace
SYSAUX Tablespace
back to top
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
back to top
Intelligent Infrastructure
Automatic SQL Tuning in Oracle Database 11g
Moving Window Baseline
Baseline Templates
Generating Baseline for a Single Time Period
Using EM to Quickly Configure Adaptive Thresholds
Changes to Procedures and Views
Automated Maintenance Tasks
Default Maintenance Resource Manager Plan