Oracle Database 10g Administration Workshop II
Course Number: Duration: 40 hours
 
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.
Target Audience Sales Consultants
Database Administrators
Support Engineer
Technical Consultant
Topics Using Globalization Support, Securing the Oracle Listener, Configuring Recovery Manager, Using Recovery Manager, Diagnostic Sources, Recovering from non-critical losses, Recovering from non-critical losses, Flashback database, Recovering from User Errors, Dealing with Database Corruption, Automatic Database Management, Monitoring and Managing Storage, Automatic Storage Management, Monitoring and Managing Memory, Managing Resources, Automating Tasks with the Scheduler.
Prerequisites Oracle Database 10g: Administration Workshop I
Oracle Database 10g: SQL Fundamentals I
Oracle Database 10g: SQL and PL/SQL Fundamentals