|
Oracle Database 10g: New Features for Administrators Release |
|
|
Course Name
|
Duration |
| Oracle Database 10g: New Features for Administrators Release 2 |
5 days |
What you will learn:
This course introduces students to the new features in Oracle Database 10g Release 2 - 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 changes that students need to understand. Hands-on practice sessions give students an opportunity to examine many of the new features, and to practice database administration with Enterprise Manager Database Control.
Learn to:
- VLDB Enhancements
- Flashback Recovery
- Automatic Management
- Enhancements to Storage Management
- Backup and Recovery Enhancements
- Enhancements Space Management
This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Audience:
- Database Administrators
- Support Engineer
- Data Warehouse Administrator
- Sales Consultants
- Technical Consultant
- Database Designers
- Project Manager
Prerequisites:
Required Prerequisites:
- 9i DBA Fundamentals
- Oracle9i Database Administration Fundamentals I
- Oracle9i Database Administration Fundamentals II
- Oracle9i Database: New Features for Administrators
Course Objectives:
- Using Database Control to simplify database management
- Proactively monitoring the database
- Increasing data availability by using improved point in time recovery features
- Implementing Automatic Storage Management
- Managing Metric Baselines
- Using Oracle Secure Backup
- Simplifying Instance Configuration
- Using Data Pump Export and Import
- Configuring the Scheduler
- Using the Automatic Workload Repository
- Managing Services
- Creating Bigfile Tablespaces
- Creating Hash-Partitioned Global Indexes
- Creating Compressed Backup sets in RMAN
- Configuring Flashback Database
- Creating the SYSAUX Tablespace
Course Topics:
- Installation
- Server Configuration
- Data Pump, SQL*Loader, and External Tables
- Database and Tablespace Data Movements
- Automatic Management
- Manageability Infrastructure
- Managing Metric Baselines
- Application Tuning
- System Resource Management
- Automating Tasks with the Scheduler
- Space Management
- Improved VLDB Support
- Backup and Recovery Enhancements
- Oracle Backup
- Flashback Any Error
- General Storage Enhancements
- Automatic Storage Management
- Maintaining Software
- Security
- Services
- Miscellaneous New Features
Suggested Next Courses:
|
