Oracle Database 10g: Administration Workshop II Page 1 of 3
Oracle Database 10g: Administration Workshop II
Duration: 5 Days
What will you learn?
In this class, you'll learn how to configure an Oracle database for multilingual applications.
Students will practice various methods of recovering the database, using RMAN, SQL, and
Flashback technology. Tools to monitor database performance and what steps to take to improve
database performance are also covered in this course. Students will also learn how to use
various database technologies, such as Resource Manager, the Scheduler, and Automatic
Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices
and a workshop. This course is designed to prepare you for the corresponding Oracle Certified
Professional exam.
Audience:
− Database Administrators
− Sales Consultants
− Support Engineer
− Technical Consultant
Suggested Prerequisites:
− Oracle Database 10g: SQL Fundamentals I
− Oracle Database 10g: SQL and PL/SQL Fundamentals
Course Objectives:
− Use RMAN to create and manage backup sets and image copies
− Recover the database to a previous point in time
− Use Oracle's Flashback technology to recover your database
− Detect block corruptions and take appropriate measures to correct them
− Use the various Database advisors and views to monitor and improve database performance
− Control database resource usage with the Resource Manager
− Simplify management tasks by using the Scheduler
− Improve the security of the listener
− Review database log files for diagnostic purposes
− Customize language-dependent behavior for the database and individual sessions
Course Topics:
1. Using Globalization Support