Overview: This course introduces students to the new features in Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.
Upon successful completion of this course, students will be able to:
- Implement improved manageability features to simplify database management
- Utilize database advisors to provide proactive database monitoring
- Increase data availability through Oracle Database 10g features that offer improved point in time recovery
- Assist developers using Oracle Database 10g features in their applications
Prerequisite(s):
To register for this course students must either take, or have the equivalent working knowledge of, the following course(s):
The Course Curriculum for Oracle Database 10 New Features for Administrators:
- Introduction How DBAs Spend Their Time
- Oracle Database 10g Manageability Goals
- Oracle Database 10g Solution: Self-Managing Database
- Grid Computing
- Oracle Database 10g: The Database for the Grid Installation
- Installation Performance
- Enhancements Installation
- New Feature Support
- Automatic pre & post install validations
- Server Configuration Database Features
- Usage Tracking Automatic Enterprise Manager Configuration
- Simplified Initialization Parameters
- Simplified Database
- Install Load and Unload Data Cross-platform
- Transportable Tablespaces
- External Tables
- Unload DataPump
- Export and Import Utilities
- Automatic Management
- Automatic Checkpoint
- Tuning Automatic Database
- Diagnostic Monitor
- Automatic Shared Memory
- Tuning Automatic
- Optimizer Statistics Collection
- Automatic Undo Retention
- Manageability Infrastructure Advisory Framework
- Automatic Routine Administration
- Tasks Server-generated Alerts / Threshold-based Alerts
- Automatic Workload Repository
- Application Management and Availability
- SQL Access Advisor
- SQL Tuning Advisor
- Improvements for Temporary tablespace groups
- RMAN Enhancements
- Flash Backup and Recovery Backup
- Compression Drop Database
- Automatic Channel Failover for Backup & Restore
- Incrementally Updated Backups
- Simplified Recovery Through Resetlogs
- Flashback Any Error
- Flashback Database
- Flashback Table
- Flashback Versions
- Query Flashback
- Transaction Query Flashback
- Drop General Storage Management
- Rename Tablespace
- Redo Logfile
- Sizing Advisor