Oracle Database 11g: New Features for Administrators - Self-Study Course

By clustering low-cost commodity server and storage modules on Infrastructure grids, Oracle Database 11g enables you to improve your user service levels, reduce down time and make more efficient use of IT resources. This particular course is designed to teach you about installation and upgrade enhancements, storage enhancements, SQL plan management and change, database replay, automatic SQL tuning, Flashback and LogMiner.

Learn To:

• Utilize database advisors to provide proactive database monitoring.
• Increase data availability by using improved ASM, RMAN and Flashback features.
• Use change management features to master database changes.
• Implement manageability features to simplify database management.
• Make enhancements in partitioning, RMAN, diagnosabilty, security and intelligent infrastructure.
• Use the Data Recovery Advisor, Oracle SecureFiles and other new features.

Oracle Infrastructure Grids

Oracle Infrastructure grids fundamentally change the way data centers look and operate, transforming data centers from silos of isolated system resources to shared pools of servers and storage. Oracle's unique grid architecture enables all types of applications to scale-out server and storage capacity on demand.

Audience

• Database Administrators
• Developer
• Technical Consultant
• Support Engineer

Course Topics Oracle Database 11g: Installation and Upgrade Enhancements

• Installing and Upgrading to Oracle Database 11g
• Database Creation and Hot Patching

Oracle Database 11g: Storage Enhancements

• ASM Administration
• ASM Commands and Extensions

Oracle Database 11g: Change Management Overview and SQL Plan Management

• Change Management and SQL Performance Analyzer
• SQL Plan Management

Oracle Database 11g: Database Replay and Automatic SQL Tuning

• Database Replay in Oracle Database 11g
• Automatic SQL Tuning in Oracle Database 11g

Oracle Database 11g: Intelligent Infrastructure Enhancements

• Automatic Workload Repository Baselines
• I/O Resource Calibration and Lightweight Jobs

Oracle Database 11g: Performance Enhancements

• ADDM, AMM, and Statistics Enhancements

Oracle Database 11g: Partitioning and Storage-Related Enhancements

• New Partitioning Methods and SQL Access Advisor

Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner

• Using RMAN Enhancements
• Using Flashback and LogMiner

Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor

• Diagnostic Enhancements in Oracle Database 11g
• Using the Data Recovery Advisor

Oracle Database 11g: New Security Features

• New Security Features in Oracle Database 11g

Oracle Database 11g: SecureFiles and Miscellaneous New Features

• SecureFiles in Oracle Database 11g
• Miscellaneous New Features in Oracle Database 11g

Course Objectives

• Use the SQL Performance Analyzer
• Upgrade your database to 11g Release 1
• Record and replay workloads
• Use the automatic database diagnostic monitor
• Explore advanced RMAN capabilities
• Manage a flashback data archive
• Use the data recovery advisor
• Setup and use ASM